Oscommerce Excel Import/Export Module

We released new contribution for oscommerce which allow administrator to import and export inventory in excel’s XLS format. The module name is Oscom Excel. A poor anolog of this script is Easy Populate module. As distinkt from Easy Populate, Excel Module doesn’t require you to convert from one file format to another, and capable to include up to 50.000 product!!! You can import and export appropratiate categories/products as well as whole stock. It support any new fields, like product attributes, languages, quantiny, manufacturers and any other fields.Here are screenshots from admin side.

1. Excel Upload and Populate page. (click on the picture to enlarge)

2. Export Your product and categories into excel file. (click on the picture to enlarge)

Click here to download example excel file which is generated by the module.

Oscom Excel Admin Usage Instruction

Step by step explanation:

1.* Make Backup of your database, from Admin/Tools/Backups. This is important, so that if you fail with excel import, you could restore your backup later.
2. Go to http://www.yoursite.com/admin/excel.php
3. Click “Generate File” link on the right side.
4. In landed page you will see option box on the right side, where you can choose any appropriate category to generate, then click generate button.
If you need to generate all inventory, then don’t select anything, the system will do it itself by default.
5. Once you clicked generate button in step 4, you will see generated xls file. Click down arrow button to download the generated file to your computer.
6. Open download file, and there you will see your inventory. Change first cells text to PPL
Where is written ID

• To delete product from stock, simply place “D” letter in URL column in excel file, for any appropriate product you wish to delete. The system will recognize this sign and delete marked product from database.
• To Edit existing product – Simply change that piece of data you need.
• To add new product – Scroll down the page to bottom and add your new product name, description, price, picture name, quantity, category name. Date available field is not important.

* Note: you should if your product to be in subcategory, you should put in this format
Category=>Subcategory, in Category_id column.
Don’t add any digit to PPL column, the system will generate new ID number itself automatically.

7. Once you completed your changes, you have to save the document in Excel 5.0/95 (*.xls) format. Just select from top menu, File, Save As, and then in appeared window, select the format. The system will ask you to save in new format, but please ignore the window, click No, so that the file saved in Excel 95. This is most important because Oscommerce won’t parse new format.
8. Once You saved the file, rename your file name, and add _changed like this products_20061202082221_changed.xls, it’s for your convenience so that you can identify your uploaded file.
9. Go back to http://www.yoursite.com/admin/excel.php
In top box, click browser button, and select the modified file from your computer, and click upload button.
10. Once the file uploaded you will see that, click “Populate from file” link next to new uploaded file, and confirm then.

* Please note: you have to upload new products pictures thru ftp into images folder.
The images file names must be the same as you specified in excel file.

* Free installation. Payment by Western Union only – www.westernunion.com

If you want to buy the script please send me an email at zaur@pdesigner.net

Project Parner – www.advancewebsoft.com

The module is sold under commercial license, and any redistribution of the module is prohibitten accordingly with International law.