Managing Export and Import
Note: This manual is for osCommerce v4.
After you accessed the admin area of your website click on “Products/Catalogue”, “Import/Export” and “Manual export” tabs. Then you can choose the required option from “File” and “Export file format” drop down lists.
After choosing a required option from from “File” drop down list you can also choose the required category from “Select category” drop down list.
If you click on Download button the pop up window will appear. For each file option Products Model field (column in the file) may have the different name. For example:
Products - Products Model
Categories - KEY_FIELD
Brands - KEY_FIELD
Assign products to categories - Products Model
Attributes - Products Model
Inventory - KEY
Supplier - Suppliers name
Stock - STOCK_KEY
Bundle - Products Model and Child Products Model
Images - Products Model
Properties - Products Model
Properties Setup - EXISTING_REF
If you click on “Manual import” tab you can “Upload File for” a certain option from the drop down list, browse and upload a required file by clicking on the corresponding buttons.
After a file appears in the list you can delete it, choose fields to be replaced from the drop down lists, apply the changes to the website and review the report by clicking on “Action” icons.
Products Model column in the file (as well as its equivalents) is mandatory for filling in otherwise there will be duplicates since this column in the file is used for record searching. Other columns in the file are optional. If they exist in the file the data will be saved otherwise if these columns do not exist in the file the data will remain unchanged.
Also for Assign products to categories, Attributes, Images and Properties options the information about the products should be added at the same time and sorted (if it is not sorted (not together) it will be removed).
For example to update the prices your product feed can be as follows (it may contain 2 columns only):