Managing Export and Import: Difference between revisions
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
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. | |||
[[File:1249 Export Import.jpg|none|thumb|800x800px]] | |||
''' | |||
After | |||
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. | |||
[[File: | [[File:1250 Select Category Products.jpg|none|thumb|800x800px]] | ||
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: | 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: | ||
| Line 32: | Line 30: | ||
'''Properties Setup - EXISTING_REF''' | '''Properties Setup - EXISTING_REF''' | ||
[[File: | [[File:1251 Select Fields to export.jpg|none|thumb|800x800px]] | ||
If you click on | If you click on '''Manual import''' tab, you can: | ||
[[File: | |||
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 | * '''upload file for''' '''a certain option''' (with format '''auto-detect''' (as per Manual Export specifications)) from the drop down list | ||
[[File: | * '''re-run previously uploaded files''' | ||
* '''browse''' and '''upload''' a required file by clicking on the corresponding buttons | |||
[[File:1252 Manual import.jpg|none|thumb|800x800px]] | |||
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. | |||
[[File:1253 Manual import new field.jpg|alt=|none|thumb|801x801px]] | |||
'''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. | '''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. | ||
| Line 42: | Line 45: | ||
For example to update the prices your product feed can be as follows (it may contain 2 columns only): | For example to update the prices your product feed can be as follows (it may contain 2 columns only): | ||
[[File:Image 591.png|none| | [[File:Image 591.png|none|thumb]] | ||
Latest revision as of 18:17, 24 February 2023
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 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.
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 (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
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):
