About Export & Import Brands

Brands list can be created by making entries with name, description, and images assigned to each in bulk. If you need to add associated brand images all at once or keep a backup of existing images data, this can be done via importing and exporting media files. 

1. Export Process  

The steps to export or download existing brands content data involves:

  1. Click on the ‘Hamburger Menu’
  2. Select ‘Import Export’, 
  3. Click ‘Export’ from the left menu
  4. Select export option ‘Brands’. 

The following information is required to be submitted to download the .csv file:

1.1 Content Tab

This tab has following information prompted to download a .csv:

  • Language: We provide you a content section to download brands list 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. 
  • Understanding Sequence Of Downloaded .csv: Open exported ‘Brands’ .csv file from your downloads folder. Once a file is accessed, data can be viewed in the following sequence:
    1. Brand Identifier*: User defined unique identifier for the Brand. This works as a unique key for the system to identify a particular Brand. 
    2. Name*: User defined name for the Brand in the system. Please note that data displayed in this column is language specific, e.g. if ‘Arabic’ language is selected from the content tab, the exported file will display Arabic data.  
    3. Description: User defined description for the Brand.
    4. SEO Friendly URL: User defined URL for the Brand for SEO purposes. Special characters/Spaces cannot be used in the URL.
    5. Active: Currently active brands are marked with ‘Yes’, whereas inactive ones are shown as ‘No’. User defined field to mark a particular category as active in the system or not. Possible inputs for this field are 'Yes' & 'No'. Default value should be set as 'Yes'.
    6. Deleted: Display deleted records as ‘Yes’ and existing records as ‘No’. In case new entries are to be added, type ‘No’ into the column to add them, whereas to restore deleted records that are showing ‘Yes’ status can be edited by entering ‘No’ to bulk restore deleted categories.
    7. Lastly, save the prepared brands content file into your document folder.
      Please note that columns marked with asterisk* are mandatory to input information and cannot be left blank. 

1.2 Media Tab

 This tab has following information prompted to download a .csv:

  • Export File Language: You can choose to export media files for all languages enabled in a system. However, for specific languages, choose from the dropdown list provided.
  • Understanding Sequence Of Downloaded .CSV  To Import Media: Before understanding the downloaded sequence, we recommend to go through the following prerequisites to avoid confusions later:
    • Open the following files simultaneously:
      • Open the auto downloaded ‘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:
  • With the file exported through ‘Media’ tab, view the following sequence of columns to prepare a media ready for import:
    1. Brand dentifier*: User defined unique identifier for the Brand. This field needs to be the same as the Brand Identifier defined in Brands Content sheet.
    2. Lang Code*: User defined field to link the brand 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 Brand has different images for each language.
    3. File Path*: Detail about system generated file path. Copy the entire ‘file path’ url from the Media .csv file opened alongside the currently opened file. Images stored locally on your personal device/machine cannot be uploaded. Preferred image dimensions are 150*90 pixels.
    4. File Name*: Details about file name of uploaded media. Copy the entire ‘file name’ url from the log file opened alongside the file you’re currently working upon.
    5. Lastly, save the prepared brands media file into your document folder.

2. Import Process

The process to import has some prerequisites to follow. 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 adding media to the server. Please note that at the time of creating a media library zip folder, the file size should not be more than your server max upload size. Know your server limit by contacting your hosting provider. 

2.1 Content Data

When you are ready, import your prepared brands data. Click on the hamburger  menu on the left, select ‘Import Export’, click ‘Import’, from the left hand menu, select ‘Import’,  select option ‘Brands’. Upon click, the following modular ‘Import Instructions’ tab will appear where information is displayed into various tabs:

  1. Instructions: On this tab, instructions about importing product brands are displayed. We recommend a thorough reading of instructions to avoid uploading errors. 
  2. 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.
    • File To Be Uploaded: Click on ‘Browse File’, locate the ‘Brands’ content .csv 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.

Check your ‘Downloads’ folder to go through the generated ‘log file’, that is marked or highlighted for errors. A  preview of ‘Log file’ is shown below:

Once corrections are made, try to re-import the file following the same import process above. In case a problem persists, contact team Growcer. 

2.2 Media Data

Once media data is setup and ready to be imported, click on the ‘Hamburger Menu’  on the left, select ‘Import Export’, click ‘Import’, from the left hand menu, select import option ‘Brands’ and choose ‘Media’ tab from the shown ‘Import Instructions’ form.

  • 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 ‘Browse File’, locate the ‘Brands Media’ file destination, click ‘Open ‘ and finally click on the ‘Submit’ button.

To access the newly created brands list, you can either view it from listing area Catalog > Brands, or can simply export the file following the export process.