EasyPopulate 4.0 Support Thread

[Kevin205]

For some reason the Model/Price/Qty does not import data, quantity or price!

I exported the PriceQty-EP2014Dec10-103644.csv, modified and imported it via PriceQty-EP2014Dec10-103644-TEST.csv. As you can see it did not update anything.
Where can I start to find out what is causing this?

Import Results

Filename: PriceQty-EP2014Dec10-103644-TEST.csv
Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 6688720
Memory Peak: 6938216
Execution Time: 0.00019407272338867 seconds.

ps. I am using Easy Populate 4.0.22 - Beta 6-10-2012 version.

[mc12345678]

For some reason the Model/Price/Qty does not import data, quantity or price!

I exported the PriceQty-EP2014Dec10-103644.csv, modified and imported it via PriceQty-EP2014Dec10-103644-TEST.csv. As you can see it did not update anything.
Where can I start to find out what is causing this?



ps. I am using Easy Populate 4.0.22 - Beta 6-10-2012 version.

My suggestion would be to review the csv file that is being provided to EP4/ZC using a plain text editor. Extra spaces before/after a column header, extra row from the top, etc... These types of things can cause the code to bail out. The code does not specifically look for that filename (yes was looking at the version described), but does have some fields that are expected as well. So could maybe provide a line or two from your file captured between code tags that are made by clicking the # symbol in the posting toolbar.

[Kevin205]

My suggestion would be to review the csv file that is being provided to EP4/ZC using a plain text editor. Extra spaces before/after a column header, extra row from the top, etc... These types of things can cause the code to bail out. The code does not specifically look for that filename (yes was looking at the version described), but does have some fields that are expected as well. So could maybe provide a line or two from your file captured between code tags that are made by clicking the # symbol in the posting toolbar.

Copied using Notepad++

v_products_model,v_status,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_msrp,v_products_quantity
XTO-7SS420524,1,,,,50,,1
JADI-P00059,1,,,,100,,119
JADI-P00060,1,,,,100,,82
JADI-P00061,1,,,,100,,68

Thank you.

[mc12345678]

Copied using Notepad++

v_products_model,v_status,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_msrp,v_products_quantity
XTO-7SS420524,1,,,,50,,1
JADI-P00059,1,,,,100,,119
JADI-P00060,1,,,,100,,82
JADI-P00061,1,,,,100,,68

Thank you.

Not sure if somewhere in the process of providing the data for posting or if at all present, but there are no double quotes used. Not saying it is a must, but files do get successfully imported when they are there. I would suggest trying the following.m
Keep the first row and the second row. Place double quotes " around each word and double quotes without a space between empty commas with a final "" at the end of each line. Save that file (two lines) and try to upload it and report results. Also can compare the file to be uploaded to the file that was downloaded to see what differences exist in general fomatting.

[Kevin205]

Not sure if somewhere in the process of providing the data for posting or if at all present, but there are no double quotes used. Not saying it is a must, but files do get successfully imported when they are there. I would suggest trying the following.m
Keep the first row and the second row. Place double quotes " around each word and double quotes without a space between empty commas with a final "" at the end of each line. Save that file (two lines) and try to upload it and report results. Also can compare the file to be uploaded to the file that was downloaded to see what differences exist in general fomatting.

Sorry for the trouble. Issue fixed!
They use excel to export the .CSV files, and saved as type MAC instead of MS-DOS. Even though they look the same in Notepad++, it wasn't importing.

Furthermore files export with "", but it can be imported without the "".


Thank you.

[mc12345678]

Sorry for the trouble. Issue fixed!
They use excel to export the .CSV files, and saved as type MAC instead of MS-DOS. Even though they look the same in Notepad++, it wasn't importing.

Furthermore files export with "", but it can be imported without the "".


Thank you.

No problem, glad the issue has been resolved. Biggest issue I've seen with using Excel and EP4 has been the date format needs to be properly situated so that ZC accepts the input. OO seems to address it without issue. :)

[keith z]

Love this plugin and have used it for many years! I have it installed and working on my newly upgraded version 1.5.3. Thank you! I've downloaded my complete products file of almost 23,000 items - Complete Products (with Metatags). In the past I have used this file to modify and send to google, bing, etc. using the the Froogle download option. Of course they ask for the item URL. Since the v_products_url_1 column is not populated it will not work. Is there a way to download URLs for each product in the file? I've seen the Google product feeder but want to sort and submit different items to each search engine.