EasyPopulate 4.0 Support Thread

[mc12345678]

Corrected in the version I uploaded Wednesday and available from https://github.com/mc12345678/EasyPopulate-4.0

But if you go to your configuration for Easy Populate and add without quotes "products_id" and then export you'll be able to manage applying a products_model if you wish (primary key of products_id or blank_new), or keep using EP4 in the blank_new/products_id setting...

Or can run a sql query... :)

[Robert Cooper]

okay i updated to ver 36 of ep i changed to the product_id and downloaded a new file now it shows v_products_model v_product_id. so what you are saying now i can auto fill my model numbers to 1001 for the first one and it stops at 2401. when i uploaded it up and imported it it added the product models with no dups. now can i change back to product model in import export primary key? and then just add my products from there?

Robert

[mc12345678]

okay i updated to ver 36 of ep i changed to the product_id and downloaded a new file now it shows v_products_model v_product_id. so what you are saying now i can auto fill my model numbers to 1001 for the first one and it stops at 2401. when i uploaded it up and imported it it added the product models with no dups. now can i change back to product model in import export primary key? and then just add my products from there?

Robert

You can change back to products_model and continue from there. You will need to be sure to always add a products_model as part of the new record(s), and if that products_model is the same as another, the last one "wins" meaning the data from the last occurrence of a products_model will replace the data of any previous one. Only caveat to that is if the categories name is different in a later row, then a linked product will be created for the later one, but all other data will replace the previous. So in effect would create a linked product with all data the same for all "versions" where the products_model is the same.

Otherwise, if you're just entering your own data with "minimal" updating from some source, then you could leave as blank_new and a new product would be identified as a products_id being blank, an existing product (or if you wanted to assign a specific products_id) would have the products_id filled in. Still recommend caution with that, because of the interrelationship of data in the database and it's dependency on the products_id.

[Robert Cooper]

Well I have all my products showing a product number now in my test store. So i did change back to product model done 1 item with the product model being 2401 and went from there it seems to have added it okay no dups or linked products. if i am seeing it correct it adds its own product id when the product is added to the store correct?

I will just keep numbering the products as 2401, 2402, 2403 etc....