EasyPopulate 4.0 Support Thread

[moesoap]

Hi Chad,

Products in my store are priced by attributes. I have installed your ep (which is fantastic) however when I try to upload new prices using Attrib-Full, it says products updated but when i check prices nothing has changed?

Is this feature not supported as yet? If not, do you know if the split files created using your version can be used in previous versions?

[chadderuski]

Hi Chad,

Products in my store are priced by attributes. I have installed your ep (which is fantastic) however when I try to upload new prices using Attrib-Full, it says products updated but when i check prices nothing has changed?

Is this feature not supported as yet? If not, do you know if the split files created using your version can be used in previous versions?

Hiya Moesoap!

There is only a basic attribute at this time. File name must start with "Attrib-EP", and only the columns in the examples directory are valid. The Export for Attributes DO NOT IMPORT as noted (yet, I'm working on this but have been inundated with work).

Once I get the Import > Export > Import "round robin" working (meaning the same file imported can be exported, edited, them re-imported), I'll be able to expand functionality like attribute pricing.

Sorry I don't have a better answer for you yet.

chadd

[chadderuski]

Hi everyone,
I'm new to both eCommerce and Zen Cart so I'm making a few mistakes but getting there slowly.
I'm using [the very wonderful] Easy Populate 4 with my Zen Cart 1.5 install to add/update about 1600 products to my fledgling site.
All is good so far but I've come across an issue that I'm sure is user error but I could do with some advice.
My products are clothes so I want to upload size and colour options for each product.
....
but the colours showed just fine on the product page, but when I imported the Sizes file all the size information was added to the Colour information in the same dropdown box.

I had not entered anything regarding options via the Zen Cart config and was expecting EP to do all this for me.
So firstly, what have I done wrong to cause this error and secondly how can I delete all the imported options data and start again?

Thanks in advance.

Hi Tedm!

You don't have to use two files to add multiple attributes to your products! These can be done one after the other for each model number.

As for figuring out what is wrong with your data files, it would be better if you ATTACHED a portion of each file so that I can see the structure.

ALSO >>> you DO NOT need EOREOR with EP4!

Did you install the MySQL Backup Mod? It is best practice to install this and make a backup before each import so you can roll the databases back if you encounter an error. Also... It is best practice to first work with a FEW records at a time, then once you are confident, the entire database.
Did you carefully read the README.txt file? I explain the attribute import in some detail there.

-Chadd

[vwaltz]

I'm having a problem loading products. This is the error I am getting:

No model field in record. This line was not imported12/640 PS" |

I'm using zencart 1.3.9
Easy Populate 4

I have unique models. so this is strange. The file is tab deliminated from Open Office.

[chadderuski]

I'm having a problem loading products. This is the error I am getting:

No model field in record. This line was not imported12/640 PS" |

I'm using zencart 1.3.9
Easy Populate 4

I have unique models. so this is strange. The file is tab deliminated from Open Office.

If you could attach a portion of the csv with headers it will help to diagnose what is going on.

[tedm]

Hi Chad,
That data I put in the above post was extracted from the two cvs files I used

I did read the readme but I don't think there's anything about importing more than one option type (I.e. sizes and colors) in a single file, which was why I used two files.

So to import two sets of options should I simply repeat the data on the same line, e.g. "v_products_model","v_products_options_values_name","v_products_options_type ","v _products_options_values_name",""v_products_model","v_products_options_values_na me","v_products_options_type","v _products_options_values_name"?

[moesoap]

Hiya Moesoap!

There is only a basic attribute at this time. File name must start with "Attrib-EP", and only the columns in the examples directory are valid. The Export for Attributes DO NOT IMPORT as noted (yet, I'm working on this but have been inundated with work).

Once I get the Import > Export > Import "round robin" working (meaning the same file imported can be exported, edited, them re-imported), I'll be able to expand functionality like attribute pricing.

Sorry I don't have a better answer for you yet.

chadd

I look forward to it Chadd. Thanks for taking the time to create this addon. It looks great and will solve many of the problems that people face with Zen.

[chadderuski]

Hi Chad,
That data I put in the above post was extracted from the two cvs files I used

I did read the readme but I don't think there's anything about importing more than one option type (I.e. sizes and colors) in a single file, which was why I used two files.

So to import two sets of options should I simply repeat the data on the same line, e.g. "v_products_model","v_products_options_values_name","v_products_options_type ","v _products_options_values_name",""v_products_model","v_products_options_values_na me","v_products_options_type","v _products_options_values_name"?

Hi Ted,

No, one record per line. You would like the SAME model number twice, but the second one will have the different options/values.

Your headers look wrong to me. That is why I prefer the attached file. I had one person that had a space after a header name that was breaking his import. Notice that you use v_products_options_values_name twice. This is wrong.

From my example file:
"v_products_model","v_products_options_name","v_products_options_type","v_produc ts_options_values_name"
"Widget","Color",0,"red,green,blue"
"Widget","Size",0,"S,M,L,XL"

First Color will be added, then Size for the same products_model number "Widget" (which must be unique to your store).

Hope this gets you one the right tray.

[vwaltz]

Hello,
I opened this file in notepad for copynpaste here.

"v_products_model" "v_categories_name_1"
"M4683G/A" "Toner-MONO^APPLE"
"M2473G/A" "Toner-MONO^APPLE"
"M2473G/A Extended" "Toner-MONO^APPLE"
"C3900A" "Toner-MONO^APPLE"
"DR400" "Toner-MONO^BROTHER"
"DR350" "Toner-MONO^BROTHER"


The above gave me the following when I imported the .csv file created with save as from open office:

Import Results


Filename: Category-EP2012Mar27-174859.csv

No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported

[tedm]

Hi Ted,

No, one record per line. You would like the SAME model number twice, but the second one will have the different options/values.

Your headers look wrong to me. That is why I prefer the attached file. I had one person that had a space after a header name that was breaking his import. Notice that you use v_products_options_values_name twice. This is wrong.

From my example file:
"v_products_model","v_products_options_name","v_products_options_type","v_produc ts_options_values_name"
"Widget","Color",0,"red,green,blue"
"Widget","Size",0,"S,M,L,XL"

First Color will be added, then Size for the same products_model number "Widget" (which must be unique to your store).

Hope this gets you one the right tray.

OK nice one.... thanks for your help