EasyPopulate 4.0 Support Thread

[stellarweb]

Customer does not remember what version - and does not remember it saying V4 - just EZ Populate. It was an old 1.5.0 website.

HOpe this helps

status Arcos Manu Number Scan Number Name Jpeg File Cost Tubes Cost X3.5 Retail v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_product_is_call v_products_sort_order v_products_quantity_order_min v_products_quantity_order_units v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_tax_class_title v_status v_metatags_products_name_status v_metatags_title_status v_metatags_model_status v_metatags_price_status v_metatags_title_tagline_status v_metatags_title_1 v_metatags_keywords_1 v_metatags_description_1 1 ARC510-00030-01700 ARC510-00030-01700 790524056132 Silver Aluminum Matte ARC510-00030-01700.jpg 1.68 1 1.68 5.88 6.00 ARC510-00030-01700 /p-czech/ARC510-00030-01700.jpg Silver Aluminum Matte ARC510-00030-01700 6.00 0 0 20 1 1 10000 XXXX Beads: Seed-Czech Arcos - 2 hole Taxable Goods 1 0 0 0 0 0 1 ARC510-00030-01710 ARC510-00030-01710 790524056163 Light Gold Matte ARC510-00030-01710.jpg 1.68 1 1.68 5.88 6.00 ARC510-00030-01710 /p-czech/ARC510-00030-01710.jpg Light Gold Matte ARC510-00030-01710 6.00 0 0 30 1 1 10000 XXXX Beads: Seed-Czech Arcos - 2 hole Taxable Goods 1 0 0 0 0 0 1 ARC510-00030-01780 ARC510-00030-01780 790524056231 Copper Gold Matte ARC510-00030-01780.jpg 1.68 1 1.68 5.88 6.00

When you say EZP are you referring to one of the other versions? There is an issue if one doesn't format the categories using the caret (^) or other self selected divider when importing categories... recommend providing an example row of data, ensuring following the instructions and lastly identifying the version currently being used/tried...

[mc12345678]

Customer does not remember what version - and does not remember it saying V4 - just EZ Populate. It was an old 1.5.0 website.

HOpe this helps

status Arcos Manu Number Scan Number Name Jpeg File Cost Tubes Cost X3.5 Retail v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_product_is_call v_products_sort_order v_products_quantity_order_min v_products_quantity_order_units v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_tax_class_title v_status v_metatags_products_name_status v_metatags_title_status v_metatags_model_status v_metatags_price_status v_metatags_title_tagline_status v_metatags_title_1 v_metatags_keywords_1 v_metatags_description_1 1 ARC510-00030-01700 ARC510-00030-01700 790524056132 Silver Aluminum Matte ARC510-00030-01700.jpg 1.68 1 1.68 5.88 6.00 ARC510-00030-01700 /p-czech/ARC510-00030-01700.jpg Silver Aluminum Matte ARC510-00030-01700 6.00 0 0 20 1 1 10000 XXXX Beads: Seed-Czech Arcos - 2 hole Taxable Goods 1 0 0 0 0 0 1 ARC510-00030-01710 ARC510-00030-01710 790524056163 Light Gold Matte ARC510-00030-01710.jpg 1.68 1 1.68 5.88 6.00 ARC510-00030-01710 /p-czech/ARC510-00030-01710.jpg Light Gold Matte ARC510-00030-01710 6.00 0 0 30 1 1 10000 XXXX Beads: Seed-Czech Arcos - 2 hole Taxable Goods 1 0 0 0 0 0 1 ARC510-00030-01780 ARC510-00030-01780 790524056231 Copper Gold Matte ARC510-00030-01780.jpg 1.68 1 1.68 5.88 6.00

While the data doesn't come across well formatted, I see the indicators that I expected for it being an older/alternate EP...

In EP4 as discussed in the instructions, the suffix '_1', '_2', '_3', etc. relates to the language that is being used... In one or more of the older versions, v_categories_name_1 was the "parent" category, v_categories_name_2 was the first sub-category off of the parent, v_categories_name_3 was the first sub-sub-category, etc...

In EP4 a specific sub-category would be generated by concatenating each of those (that have content) with the carat '^'...

So:

v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6
shirt                 long-sleeve           no-buttons

for EP4 would be combined in a single field (v_categories_name_1 or (when using the most recent version) v_categories_name_en) to:
shirt^long-sleeve^no-buttons

Where the language_id for the store is 1... While not fully implemented across all import file types, the language_code is now supported to instead use '_en' as the suffix for English instead of the language_id (_1).

A way to accomplish that concatenation if the columns were say g, h, and i with the data starting in row2, then I would go to the next/last v_categories_name_X column, insert a new column, then use something like:

=IF(G2<>"",  G2, "") & IF(H2<>"", "^" & H2, "") & IF(I2<>"", "^" & I2, "")

Now of course I wouldn't expect that there would be a "series" of information followed by an empty space then another with data (say _1 and _3 having data, but _2 not having data)...

After I got the result, then I would copy that function down to the last row, then copy the contents in that column for all product and paste special that text into the appropriate column representing the language_id and delete the other v_categories_name_X columns including the one that was created to support this effort...

Basically, EP4 supports multiple languages which older types did not appear to do so and the categories/sub-categories are identified as between each ^.

This is also why it is important to not introduce spaces before/after each category. " shirt" is different than "shirt" and results in category creation/population to the "applicable" category....

[jimmie]

zen 1.56c with many modules
easy populate downloads one field funny, as in the data base (products_barcode varchar(32))
when i upload it back it uploads whats in the file.
tried to upload file but exceed quota, but here is some of what is in the file
v_products_barcode
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11

[mc12345678]

zen 1.56c with many modules
easy populate downloads one field funny, as in the data base (products_barcode varchar(32))
when i upload it back it uploads whats in the file.
tried to upload file but exceed quota, but here is some of what is in the file
v_products_barcode
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11

At some point in modifying the exported data, it appears that the spreadsheet being used stopped considering the text provided as text and started treating it like a number... it then considered the number to need to be displayed in exponential numbers... therefore when the spreadsheet was saved to a csv file, the file then contained exponential numbers...

This all happened outside of EP4 and specifically in the spreadsheet being used... you'll likely have to go back a few exports to find the original values that were brought into your spreadsheet program. In the future treat this field as a text field and don't let your spreadsheet program convert it to a number...

[jimmie]

my steps were, open ep, choose manufacturer, than export, than download to computer, than open in excel. than i copied some rows pasted them here.

[mc12345678]

my steps were, open ep, choose manufacturer, than export, than download to computer, than open in excel. than i copied some rows pasted them here.

"Looking" at them in excel is why the numbers are converted to the scientific notation that was posted... Again, this is not something that was done in EP4. EP4 generates the CSV file that was downloaded. If it is looked at with your favorite plain text editor just after download and before ever being edited with Excel or Open Office then will see the number(s) in their entirety and not shortened.

There are plenty of ways to request that numbers be treated as text when either importing a file or reviewing the content.

[djdavedawson]

v_products_barcode
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11
7.34995E+11

Jimme,

I had the same issue with UPC codes, it's a pain.

Here is how I solved it.

I added UPC before every code in the database, so instead of this -> 697666007421 in the db it was this -> UPC697666007421

Then i used php to remove the UPC when it's displayed on the front end.

str_replace("UPC","",$upc['products_upc']) 

It's a workaround but solves that issue.

[DrByte]

In Excel, to "format number fields as text instead of scientific notation", select the entire column, press CTRL+1 (or CMD+1) and change the format to Text

https://www.excelhow.net/convert-sci...-in-excel.html
https://www.extendoffice.com/documen...n-to-text.html

[greg_beyer]

Hello, I'd like to make sure that this plugin fits my use case before proceeding.

We have existing categories on our ZC 1.5.5e site, to which we need to add 125 or more products. Do I understand that with this plugin, I can put the 125 products into an appropriately formated / column header CSV, and mass import my products in one operation? Thus avoiding the tedious GUI of creating 125 products. Thanks for clarifying.

[mc12345678]

Hello, I'd like to make sure that this plugin fits my use case before proceeding.

We have existing categories on our ZC 1.5.5e site, to which we need to add 125 or more products. Do I understand that with this plugin, I can put the 125 products into an appropriately formated / column header CSV, and mass import my products in one operation? Thus avoiding the tedious GUI of creating 125 products. Thanks for clarifying.

Absolutely correct. Suggest exporting product from that category (if at least one is already present) to make a good example of how it should look when preparing the new upload. (remember that the csv file has a different appearance than that content loaded into a spreadsheet.)