Exporting your products for EZFeed

ZenCart and OSCommerce Instructions

ZenCart and OSCommerce use the EasyPopulate plugin to export product information from the database. You export a Froogle data file from your cart. Then a few simple steps are required to prepare your file for EZFeed.

1. Download Froogle tab delimited TXT file from your ecommerce administration.
2. Open the file in Excel
3. Keep first 6 columns (A-F), delete other columns
4. Clean up HTML in Column F (category) by doing find/replace <B> with nothing.
5. Move column D (price) to last column.
6. Delete header row.
7. Save as tab delimited TXT file, give it a different file name so you still have original export if needed.
8. Upload to EZFeed server

Yahoo Store Instructions

1. Go to the http://www.yourdomain.com/objinfo
2. Wait until browser loads.
3. Copy and Paste Special into cell A1 in a new Excel worksheet.
4. Delete ALL COLUMNS EXCEPT OBJ NAME PRICE THUMB SPATH
5. Select Column A, and insert two columns. You will have a new blank Column A and B.
6. Select cell B2. Enter the following formula EXACTLY as it appears below:

   ="http://yourwebsiteURLhere/"&C2&".html"

7. Select from B2 all the way down to the last row in B2 for which there is an item. Choose Edit -> Fill -> Down.
8. With the column of data still selected, Copy. Select cell A2 and choose Edit -> Paste Special. Click the Values radio button. Click OK.
9. Delete Columns B and C.
10. Select Column C and insert a column.
11. Select Column B. Copy. Select Column C. Paste.
12. Select Column D. Insert a Column.
13. Select Column F. CUT. Select Column D. Paste.
14. Select Column E. CUT. Select Column F. Paste.
15. Select Column G. CUT. Select Column E. Paste.
16. Select Column D and insert two columns. You will have a new blank Column D and E.
17. Select All. Go to Data>Sort. Select the Header Row radio button. Sort by THUMB in Ascending order.
18. Select cell E2. Enter the following formula EXACTLY as it appears below:

    =MID(F2,38,LEN(F2)-38)

19. Select from E2 all the way down to the last row in E2 for which there is an item. Choose Edit -> Fill -> Down.
20. With the column of data still selected, Copy. Select cell D2 and choose Edit -> Paste Special. Click the Values radio button. Click OK.
21. Delete Column E and F.
22. Select the first row and delete it.
23. Save the file as a tab delimited text file. There should be no spaces in the file name.

Volusion Stores

These instructions are for customers that have a Volusion store. They must log in to their account and follow these instructions to export their data feed and upload to Wholesale Central.

1. Click on the INVENTORY TAB then on IMPORT/EXPORT.
2. Click on the Data Export link.
3. Choose PRODUCTS from the table drop down box.
4. Choose Product URL, Category Tree and Photo URL from the Virtual Column.
5. Choose ProductName from the Products Columns.
6. Choose Product DescriptionShort from the Product_Description columns.
7. Choose ProductPrice from the Products_Extended Columns
8. Scroll to the bottom and choose TAB Delimited Text File from the Export to drop down box.
9. Click the Export my data button.
10. Wait while file is being saved.
11. You will be redirected to the Data Export Wizard Page. RIGHT Click the Link that says click here to download your file. Depending on your browser, you will be asked to save target or link as. Save it to your desktop.
12. FIXING THE FILE IN EXCEL: Open the file in Excel.
13. Rearrange the columns so that they are in the following order:
1. Product Url
2. Product name
3. Product Description Short
4. Photo Url
5. Category Tree
6. Product Price
14. Delete the header row and upload file as usual.