Table of Contents
1. Export Processa. Content Tab: This tab has following information prompted to download a .csv:b. Media Tab2. Import Processa. Content Datab. Media DataWhile Growcer allows you to manually create a catalog and add catalog entries. However, this option is less useful when it comes to managing a large catalog and that too when options, tags and specifications are involved. Therefore, use import/export options to efficiently move products into and out of a catalog through a simple .csv file. The following import/export options are available:
- Product Catalog: With this option, catalog can be created, updated and deleted.
- Product Options: It is likely that many of your products are available in different sizes and/or colours. Create and import product options by entering the product option types you want to use in your storefront.
- Product Tags: Update, delete, add tags on product catalog in bulk.
- Product Specifications: Start adding products specifications, update, delete in bulk.
1. Export Process
The steps to export or download currently listed catalogs content data involves:
- Click on the ‘Import Export’ from the left navigation menu.
- Select ‘Export’ from the displayed modular tab.
- A list of options available for export is displayed, select ‘Catalogs’.
a. Content Tab: This tab has following information prompted to download a .csv:
- Language: We provide you a content section to download data into multiple languages as added by admin in the system. For instance, if you want to save content in English language simply select language English and submit. Similarly for other languages follow the above process with respective languages.
-
Select Data:Select data option from the following dropdown list.
- Product Catalog
- Product Options
- Product Tags
- Product Specifications
-
Export Data Range: Select range of data to export from. Know what are the available options:
- Doesn’t Matter: Will display complete catalog records in one go. Please note that the default upper limit for data export is set to 1000. However, if your existing catalog has more than 1000 entries, opt for export Id range or batch wise options.
- By Id Range: This option allows you to export catalog products within a selected range e.g. Set the ‘Start ID’ as 5 and ‘End ID’ as 15. Only the set/asked range records will be displayed.
- By Batches: This option allows you to export catalog products batch wise. There is a provision to export records in batches. Suppose, there are 50 records available and the decided size of the particular batch to be exported is 10. So this allows the admin user to create 5 separate batches.
- Understanding Sequence Of Downloaded .csv For Product Catalog: Open the downloaded product catalog file and start adding/editing product catalog information using the relevant columns. Data can be viewed in the following sequence:
- Product ID: Display unique product ID. This works as a unique ID for the system to identify a particular product.
- Product Identifier*: User defined unique identifier for the product. This works as a unique key for the system to identify a particular product.
- Username: If added by the seller, the name of the seller will be displayed, otherwise it will show admin’s name.
- Name*: User defined field for product name. Add/edit/update names.
- Description: User defined field for product description. Add/edit/delete information as required.
- Youtube Video: User defined field for product Youtube video URL. Add/edit/replace new links with existing ones.
- Category Identifier*: User defined unique identifier for the category. This field needs to be the same as the ‘Category Identifier’ defined in the Categories Content sheet. Make edits/additions/changes as required.
- Brand Identifier*: User defined unique identifier for the Brand. This field needs to be the same as the ‘Brand Identifier’ defined in the Brand Content sheet. Make edits/additions/changes as required.
- Model: User defined field for product model. Make dits/additions/changes as required.
- Min Selling Price*: User defined field for minimum selling price for the product. Make edits/additions/changes as required.
- Tax Group Identifier*: User defined unique identifier for the Tax category. This field needs to be the same as the ‘Tax Category Identifier’ defined in the Admin section under the Tax Management section. Make edits/additions/changes as required.
- Ean/upc/gtin Code: User defined field for EAN/UPC code of the product. Make edits/additions/changes as required.
- Approved: User defined field to mark a particular Product as Approved or not. Possible inputs for this field are 'Yes' & 'No'. Default value should be set as 'Yes' to display products in the system.
- Active: User defined field to mark a particular Product as active in the system or not. Possible inputs for this field are 'Yes' & 'No'. Default value should be set as 'Yes'. Make edits/additions to this column by entering information either in ‘No’ or ‘Yes’.
- Deleted: User defined field to mark a particular product as deleted in the system or not. Possible inputs for this field are 'Yes' & 'No'. Default value should be set as 'No' to display products in the system.
- Product Veg Status: User defined field to mark a particular product as Veg & Non-Veg in the system or not. Possible inputs for this field are 'VEG' & 'NONVEG'.
- Lastly, save the prepared content file into your document folder.
Columns marked with asterisk* are mandatory to input information and cannot be left blank.
-
Product Options: To export/download product options data, it is must to enter information into the following displayed field:
-
Language: We provide you a content section to download data into multiple languages as added by admin in the system. For instance, if you want to save content in English language simply select language English and submit.
Similarly for other languages follow the above process with respective languages -
Select Data: Select data option ‘Product Options’ from the dropdown menu.
-
Understanding Sequence Of Downloaded .csv For Product Options: Open exported .csv file. At this point you also need to decide how data is thought to be imported back into the system. Once a file is accessed, data can be viewed in the following sequence:
- Product Identifier/ID*: User defined unique identifier for the Product. This field needs to be the same as the ‘Product Identifier’ defined in the Product Catalog Content sheet.
-
Option Identifier*: User defined unique identifier for the Option. This field needs to be the same as the ‘Option Identifier’ defined in the Option Content sheet. Please note that each product can only be binded/associated with one option. Also it is noteworthy to know thatoptions need to be pre-exists in the system for the product to bind with. Enter new/edit/replace new products with new ones.
Columns marked with asterisk* are mandatory to input information and cannot be left blank.
-
Language: We provide you a content section to download data into multiple languages as added by admin in the system. For instance, if you want to save content in English language simply select language English and submit.
-
Product Tags: This option is catered to bind tags with the catalog products. To export/download product tags data, the following information is required to be submitted to download the .csv file:
- Language: We provide you a content section to download categories in multiple languages as added by admin in the system. For instance if you want to save content in English language simply select language English and submit. Similarly for other languages follow the above process with respective languages.
- Select Data: Select data option ‘Product Tags’ from the dropdown list.
-
Export Data Range: Select range of data to export from. Know what are the available options:
- Doesn’t Matter
- By Id Range
- By Batches
-
Understanding Sequence Of Downloaded .csv For Product Tags: Open exported .csv file and once a file is accessed, data can be viewed in the following sequence:
- Product Identifier*: User defined unique identifier for the Product. This field needs to be the same as the ‘Product Identifier’ defined in the Product Catalog Content sheet. Enter new/edit/replace new products with new ones.
- Tag Identifier*: User defined unique identifier for the Tag. This field needs to be the same as the ‘Tag Identifier’ defined in the Tag Content sheet.
- Delete Product Tag: User defined field to mark a particular product tag as deleted in the system or not. Possible inputs for this field are 'Yes' & 'No'. Default value should be set as 'No' to display tags in the system.
- Lastly, save the prepared content file into your document folder.
Columns marked with *asterisk are mandatory to input information and cannot be left blank.
-
Product Specifications: This option is catered to bind specifications with the catalog products. To export/download product specifications data, it is must to enter information into the following displayed field:
-
Language: We provide you a content section to download data into multiple languages as added by admin in the system. For instance if you want to save content in English language simply select language English and submit.
Similarly for other languages follow the above process with respective languages. - Select Data: Select ‘Product Specifications’ from the listed data options.
-
Export Data Range: Select range of data to export from. Know what are the available options:
- Doesn’t Matter
- By Id Range
- By Batches
-
Understanding Sequence Of Downloaded .csv To Import Content Data For Product Specifications: Open exported .csv file and once a file is accessed, data can be viewed in the following sequence:
-
Product Identifier*: User defined unique identifier for the Product.
This field needs to be the same as the Product Identifier defined in the Product Catalog Content sheet. Enter new/edit/replace new products with new ones. - Lang Code: Display language into which data has been exported.
- Specification Name*: Showcase name added to specification.
- Specification Value*: Specify product associated value of specification.
-
Delete Specification: Display deleted specifications as ‘Yes’ and existing ones as ‘No’.
Columns marked with asterisk* are mandatory to input information and cannot be left blank.
-
Product Identifier*: User defined unique identifier for the Product.
-
Language: We provide you a content section to download data into multiple languages as added by admin in the system. For instance if you want to save content in English language simply select language English and submit.
b. Media Tab
The following information is required to be submitted to export catalog media into .csv:
- Export File Language: We provide you a content section to download media in multiple languages as added by admin in the system. For instance, if you want to save content in English language simply select language English and submit. Similarly for other languages follow the above process with respective languages.
-
Export Data Range: Select data option from the drop-down list. Select from available options:
- Does Not Matter: This option will export/download complete catalog media.
- By Id Range: This option allows exporting catalog media within a selected range say between 5 to 30 or 35 to 50 and so forth.
-
By Batches: This option allows exporting catalog media in predefined batches. Say for ‘Batch Number ‘1’, the expected count of counts is 10.
Once you click on the ‘Submit’ button, check the downloaded media into your downloads folder.
-
Understanding Sequence Of Downloaded .CSV: Before understanding the downloaded sequence, we recommend to go through the following prerequisites to avoid confusions later:
- Open the following files simultaneously:
- Open the ‘Media .CSV File’ that has been obtained when the media file has been sent to the server.
- Open the exported media .csv file downloaded through Media Tab above.
- Once you have files opened mentioned above, go through the following sequence of columns to prepare media data:
- Open the following files simultaneously:
- With the file exported through media tab, view the following sequence of columns to prepare a media ready for import:
- Product Identifier*: User defined unique identifier for the Product. This field needs to be the same as the Product Identifier defined in the Product Catalog Content sheet.
- Lang Code: User defined field to link the product image for a particular language. 'Universal' is to be used as an option to link the media in all languages. Language codes can be looked up by clicking the language option in the top header. Language codes need to be used if the Product has different images for each language.
- Option Identifier*: User defined unique identifier for the option. This field value needs to be the same as the Option Identifier defined in the Options Content sheet.
- Option Value Identifier*: User defined unique identifier for the option value. This field value needs to be the same as the Option value Identifier defined in the Options Value Content sheet.
- File Path*: Detail about system generated file path. Copy the ‘file path’ from the Media .csv File opened alongside with the currently opened file. Images stored locally on your personal device/machine cannot be uploaded. Preferred image dimensions for the product images are greater than 500*500 pixels.
- File Name*: Details about file name of uploaded media. Copy the ‘file name’’ from the Media .csv File opened alongside the file you’re currently working upon.
- Display Order: This column is dedicated to showcase display order of associated product images. Based on the numerical inputs orders are decided. When a product has multiple images then this field defines the order of display. If you are unsure about this field add display order as '1'.
2. Import Process
For ‘Content’ once required information is added/edited, double check your data and format of file in case you have opted to create your own .csv file.
Check the file for formatted headers and columns so that mandatory fields cannot be left blank. Whereas, for ‘Media’ ensure that you have followed the prerequisites by Upload Bulk Media In addition to this, to prepare and complete importing media you need to open the following downloaded files simultaneously:
- Open the exported media .csv file downloaded through ‘Media Tab’ above.
- Open the media .zip file obtained once the media file has been sent to the server.
a. Content Data
Once the data has been added and ready to import,
- Click on the ‘Import Export’ from the left navigation menu menu,
- Select ‘Import’ from the modular tab and select ‘Catalogs’ to confirm from the displayed options. The following information is displayed into various tabs:
- Instructions: On this tab, go through instructions set for each data type separately. We recommend a thorough reading of instructions to avoid uploading errors.
-
Content: On this tab, the following fields are displayed to import data:
- Language: Select imported language file from the dropdown list provided. Please note that the list of languages displayed has a direct relation with the number of languages enabled in the system.
- Select Data: Select ‘Data’ from the various options displayed. Please note selection of data is dependent on the exported data file and its preparation.
-
Select relevant option:
- Product Catalog
- Product Options
- Product Tags
- Product Specifications
- File To Be Uploaded: Click on ‘Choose File’, locate the file, click ‘Open’ and then ‘Submit’. The ‘Data Imported/Updated Successfully’ message will be displayed when the file is uploaded within the system.
Exit the section and congratulations you have successfully uploaded/updated newly added data into the system. In case of any discrepancies found, an error message is displayed and a log file will be automatically generated. A preview of log file can be in the screenshot below:
Go through the log file, mark the areas highlighted for error and re-import. In case a problem persists, contact team Growcer.
b. Media Data
Exporting catalog media is useful if you want to make many changes to your catalog inventory or bulk upload images. Please note that to update media library files in bulk a compressed zip folder is created containing all the media images intended to upload. Learn how to add media to the server in the next section.
Here it is noteworthy to know that media upload is catered only to the ‘Product Catalog’ option. Other available options such as product tags, options, specification are excluded as they do not contain any media library. Learn how to upload bulk media from here.
Once media data is set up and ready to be imported, Select ‘Import’ from the modular tab and select ‘Catalogs’ to confirm from the displayed options.
Lastly select ‘Media’:
- Upload File Language: Select the language from the drop-down list media file is set up for import.
- File To Be Uploaded: Click on the ‘Choose File’, locate the file destination, click ‘Open ‘ and finally click on the ‘Submit’ button.