Easypopulate 4 Question

[decalman]

HI there,

I am trying to work out how to add my products via Easy pop 4, I have added 1 x product with the attributes i require through admin and downloaded the CSV file for the attibutes, I then tried to add another product using the CSV however when i goto import the file it comes up with SKIPPED! - Attribute Entry on Model: dk_0601k0116 - Not Found!. I am only adding the products to the Attrib-Detailed-EP2016Feb24-001019 file, should i be edditing other CSV files as well??

Anyhelp will be fantastic as i have around 2000 products to add with different attributes and through admin will take a very very long time

Thank you in advance

Glenn

[mc12345678]

HI there,

I am trying to work out how to add my products via Easy pop 4, I have added 1 x product with the attributes i require through admin and downloaded the CSV file for the attibutes, I then tried to add another product using the CSV however when i goto import the file it comes up with SKIPPED! - Attribute Entry on Model: dk_0601k0116 - Not Found!. I am only adding the products to the Attrib-Detailed-EP2016Feb24-001019 file, should i be edditing other CSV files as well??

Anyhelp will be fantastic as i have around 2000 products to add with different attributes and through admin will take a very very long time

Thank you in advance

Glenn

Welcome to ZC. As a new poster, please be advised that when addressing an issue with a plugin, that is typically best to post to the thread related to that plugin. The EP4 instructions identfy that as: https://www.zen-cart.com/showthread....d&goto=newpost (although this link will take a visitor to the latest post identified as being read by the individual clicking it.)

Others familiar with the plugin can help more "reliably", meaning, someone is more likely to know the answer and be able to help, and others trying to use the plugin can learn from what is posted.

[mc12345678]

Easypopulate question. (we are using 2.8 version but can modify it to bring current or change process)

Our distributors products change daily and so we have edited the site to add products daily using easy populate. The problem is if the site has a product and the distributors list does not have a product the next day (completely deleted from the next sheet to import), easypopulate has no way of deleting it. Any suggestions?

For one, don't suggest posting the same message throughout the forum... This question was asked in the appropriate thread originally and now in this thread related to EP4... That said, probably wouldn't have said something about it if the question had been asked a little differently.

That said, would say it doesn't matter what version is being used, as the datafile provided by your supplier is definitely not store friendly... There are a couple of ways I can see dealing with this if the supplier refuses to change their process of providing the file (either stock quantity of zero or some indication of product being deleted).

Could run a comparison of today's file against yesterdays to identify the absence of rows and initiate the deletion/inactivation of the product, could while importing identify some sort of flag to capture that a particular product was updated and when compared to a query of the database for all product from that supplier the items in the query response that are not in the "tracking" group are to be deleted/disabled. EP4 has the ability to effect either condition. Either that product is enabled/disabled or with a status of 9 it will be deleted.

[mc12345678]

Thank you! I posted in a forum that stopped talking about EP back in 2011 I think so I edited and removed it and posted it here, apologies if I did something wrong - won't happen again.

We have a couple of different sites and the datasets are the same. When they drop the products they drop the products from the csv or api or xml - which is driving me crazy. Trying to turn those off using standard EP scripts (heavily modified to handle 30,000 products) still leaves the dangling discontinued files. Thanks for the insight, may have to write a separate mysql or php routine to do just what you said. Oh, the joys of ecommerce :)

No problem, and technically this thread is just a single spin off of the main thread for EP4.

Really suggest talking with that supplier. The file does no good really other than could completely remove the product from that supplier and then put it all back, but problem is that generally speaking restoration of the product would result in a new products_id and therefore the "internet" would see it as a completely new product each and every day. Now version 4.0.33 and above of EP4 does permit populating the database by products_id, so one could destroy and recreate if the products_id can be carried over from one day to the next/before deleting the old...

Whatever the case, want to minimize the need for any daily ineraction with the site as part of this process...

I was kind of thinking of a single variable array where the key in the array is possibly the product identifier, and then as part of the sql query, loop through and when query returns an identifier not in the array,take action (don't know if this is a no-longer carrying condition or a "oops" we're out of stock at the moment condition.

[schoolboy]

A product status of "0" (zero) will show the product as "Out of Stock" (depending also, on some stock status settings in admin panel).

You can "update" this status using SQL commands via SQL injections in the TOOLS menu of your admin:-
EG

UPDATE  `products` SET  `products_status` =  '0' WHERE  `products`.`products_id` =13455;
UPDATE  `products` SET  `products_status` =  '0' WHERE  `products`.`products_id` =21405;
UPDATE  `products` SET  `products_status` =  '0' WHERE  `products`.`products_id` =43252;
UPDATE  `products` SET  `products_status` =  '0' WHERE  `products`.`products_id` =12459;
UPDATE  `products` SET  `products_status` =  '0' WHERE  `products`.`products_id` =55434;

The products ID is the zencart-attrributed ID.

Some years ago I found a developer who wrote a module to take a supplier's data feed and (in essence) do these "update" commands using CRON. At the time, our supplier FTP'd the stock status file to our server at midnight. The script ran (using CRON) at ten past midnight.
us