EasyPopulate 4.0 Support Thread

[SPH]

One this that is important to remember!

The BASIC import can be used to CREATE and MODIFY the options names and options values names attached to a specific product.

But the DETAILED is ONLY used to UPDATE a specific products model, option name, options values name combo. This is why those first columns must remain untouched. The _id's are used to find and update that specific combo. Although not very flexible, this works well and is quick.

I am waiting for feedback on what COMMON additional columns would be useful for the BASIC import, but have not received any feedback on that yet.

I hope this clears things up.

Chadd,

ZC 1.5, this product:
http://www.webdivision.prommart.com/...roducts_id=191

We think we know how your Basic Attributes work.

But we probably really need the Detailed Attributes sheet to do our V-Lookup thing off of the column headings I mentioned some months ago.

I guess my question is: Can I use the Detailed Attributes sheet to ADD another color to this product? If so, how.

I tried and think that I am stuck on column A...v_products_attributes_id

I tried adding what should be the next number in order, but didn't work.

Thanks.

Steve

[chadderuski]

Chadd,

ZC 1.5, this product:
http://www.webdivision.prommart.com/...roducts_id=191

We think we know how your Basic Attributes work.

But we probably really need the Detailed Attributes sheet to do our V-Lookup thing off of the column headings I mentioned some months ago.

I guess my question is: Can I use the Detailed Attributes sheet to ADD another color to this product? If so, how.

I tried and think that I am stuck on column A...v_products_attributes_id

I tried adding what should be the next number in order, but didn't work.

Thanks.

Steve

Hi Steve,

First, from an earlier post:
One this that is important to remember!

The BASIC import can be used to CREATE and MODIFY the options names and options values names attached to a specific product.

But the DETAILED is ONLY used to UPDATE a specific products model, option name, options values name combo. This is why those first columns must remain untouched. The _id's are used to find and update that specific combo. Although not very flexible, this works well and is quick.

You cannot use the detailed sheet to add colors. What you'd do first is run the basic with the products model number and options name to add options values name.
Then export your detail sheet which will now have all the colors assigned to that products.

Does that help to clear things up?

[jandm-ent]

we are having a problem with Quantity Units errors after updating our qty in stock via easy populate. So far the only way we have been able to find to fix the error in through the catalog in the admin section, going into every item individually and updating them. This is not reasonable for us as we have 16,000+ items. Is there any way to fix this or are we doing something wrong?

Easy populate 4
Zencart 1.5

[chadderuski]

we are having a problem with Quantity Units errors after updating our qty in stock via easy populate. So far the only way we have been able to find to fix the error in through the catalog in the admin section, going into every item individually and updating them. This is not reasonable for us as we have 16,000+ items. Is there any way to fix this or are we doing something wrong?

Easy populate 4
Zencart 1.5

I have tested this and do not believe it is a problem with the script. Also, you did not describe what error you are getting. Have you done an export with a small sub-category, downloaded it, changed the v_products_quantity column, resaved as CSV and uploaded/imported to see if the values recorded correctly?

I just did this, and it worked find. Now, if your column header is "v_products_quantity " <--- see that extra space? That will kill the column, and it will not import.

General note to all:
When having issues like this it really helps to attached a portion of your import file. And when testing, don't start with a massive import! First verify that you know your columns are working correctly by importing only a couple records, then carefully check each record's entry for accuracy. I have done this literally hundreds of time.

Now, most times it's the CSV data, but sometimes it's the script. So you should always include the version number in your posts. You should all update to 4.0.21 because of the mixed update/new data error I discovered when importing sheets with reduced columns (that had to have been in there for sometime!) ... along with all the other corrections and tweaks.

-chadd