Managing Export and Import

From osCommerce Wiki
Jump to navigation Jump to search

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.

1249 Export Import.jpg

After choosing a required option from File drop down list, you can also choose the required category and product from Select category and Products drop down lists, and use Price with tax option.

1250 Select Category Products.jpg

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


Bundle - Products Model and Child Products Model

Images - Products Model

Properties - Products Model

Properties Setup - EXISTING_REF

1251 Select Fields to export.jpg

If you click on Manual import tab, you can:

  • upload file for a certain option (with format auto-detect (as per Manual Export specifications)) from the drop down list
  • re-run previously uploaded files
  • browse and upload a required file by clicking on the corresponding buttons
1252 Manual import.jpg

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):

Image 591.png