Easy Populate for mass product addition

[finlander]

I've been using Easy Populate CSV to add about 300 products. I created a csv file using the Zen architecture and the addition went fine. The addition of the products did not include images or product description, just titles, price, quantity. Just the basics. I'll add images and descriptions manually.

I noticed that there was no field for max qty purchasable (products_quantity_order_max) and qty box status (products_qty_box_status to show it or not) in the tables that Easy Pop builds.

Using the zen architecture, I added these fields to my csv and populated with "1s" or "0s" as I needed. Problem is, these fields are not recognized, at all, at upload run time using Easy Populate. Another clue was my Easy Pop downloaded zen table, from existing products, also did not contain these fields. It's as though these fields are outside the universe of Easy Populate's available fields.

I wonder if I could run a simple sql UPDATE command to change all max qty to 1 and change all show qty box to 0.

[finlander]

okay, this may help someone else, and it's easy. I needed a global value change on a couple more fields after using Easy Populate, but EP wouldn't recognize the field names when I tried to run them through the EP update routine. So, I ran SQL executes to make the needed changes:

UPDATE products SET products_quantity_order_max="1";

and

UPDATE products SET products_qty_box_status="0";

So, at this point, I'm not sure when I will be able to use EP because of the fields it didn't recognize (or if I am not using correct syntax or something), but we can always use SQL executes for simple changes like this.

[finlander]

well, come to find out, Easy Populate CSV is worthless if you have more than one language on your store. My 300 products went into a category on the English side, because I specified a category using v_categories_name_1 in the EP upload, but on the German side of my store, all 300 got dropped into the top level of categories, rather than in a category. The products are all just loose in the top level (even though that's not supposed to be allowed when categories also exist in the top level. I'm getting rid of Easy Populate -- it didn't work well to begin with and it can't handle an additional language at all.