This option is provided to manage the Sellers own inventory. Inventory related information such as product stock, selling price, min order quantity, threshold stock level, availability, sold count and so forth can be traced as well as updated or created in bulk through an import option.

1. Export Process

To export seller products inventory:

1. Click on the ‘Import Export’ on the left navigation menu.
2. Select ‘Export’ from the displayed modular tab.
3. Select ‘Seller Products’ from the list of options available for export.
   1. Content Tab: This tab has following information prompted to download a .csv:
      
      • Language: We provide you a content section to download data 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 various content data options available:
        • General Data
        • Product Options
        • Seo Data
        • Special Price
        • Volume Discount
        • Buy Together
        • Related Products
      • Export Data Range: Select data range for all the above options. Depending upon the options selected, the results in .csv downloaded can be generated.
        The following options are available :
        • Does Not Matter: Without any distinction this option will export/download complet seller products.
        • By Id Range: This option allows limiting the seller product catalog as defined, say between 5 to 30 or 35 to 50 and so forth.
        • By Batches: This option allows exporting catalog data batchwise. Say for ‘Batch Number ‘1’, the expected count of counts is 10. Once the required option is selected, click on the ‘Submit’ button, and check your download folder.
          

I. Seller Products- General Data

The exported seller products inventory CSV file contains information about general information of Sellers’ inventory. Alongside this, the Seller also has an option to export/import seller products inventory and manage those individually.

• Understanding Sequence Of Downloaded .csv: Open exported .csv file and once it is accessed, data can be viewed in the following sequence:
  1. Seller Product Id: User defined unique id for the Product. This field needs to be unique. Please note that in case new product IDs are added, meaning there is no already matching entry into the system, it is considered as a new catalog and added into the list. However, in case a newly created product Id matches with the one that pre- exists, by default the system picks it up for update and overwrites previously added entries with the same ID/Identifier with new one.
  2. Product Identifier: User defined identifier for the Product. This column needs to be the same as the ‘Product Identifier’ defined in the ‘Product Catalog’ sheet.
  3. Selling Price: Explain selling price of the product
  4. Cost Price: Explain cost price of the product
  5. Stock: Quantity available for the product
  6. SKU: Unique SKU number of the product.
  7. Min Order Quantity: Minimum quantity that a buyer can purchase for the product.
  8. Subtract Stock: User defined field to mark if the system should subtract stock or not once an order is placed. Possible inputs for this field are 'Yes' & 'No'.
  9. Track Inventory: User defined field to mark if the system should monitor inventory or not. Possible inputs for this field are 'Yes' & 'No'.
  10. Threshold Stock Level: User defined field to input threshold stock level upon which the system would generate an alert email. This will only work if both Subtract Stock & Track Inventory are set as 'Yes'.
  11. Title: User defined field to define the title of the product in the shop.
  12. Comments: User defined field to input comments for the product.
  13. URL Keyword: User defined field for input of URL keywords, used for URL rewriting
  14. Available From: User defined date field to input the date the product is available from. Date format is mm/dd/yy.
  15. 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' to display products in the system.
  16. Deleted: Products deleted from listed products are marked as ‘Yes’, whereas for displayed products, it is represented as ‘No’.
  17. Lastly, save the prepared ‘Seller Product General Data’ into your document folder.

II. Seller Product Options: Exported sellers’ product options file contains information about the product options available to sellers registered with the portal.

• Understanding Sequence Of Downloaded .csv To: Open exported .csv file and once it is accessed, data can be viewed in the following sequence:
  
  1. Seller Product Id: User defined product identifier for the Product. This field needs to be the same as the 'Seller Product Identifier' defined in the Seller Product General Data sheet.
  2. Option Identifier: User defined unique identifier for the Option. This field needs to be the same as the ‘Option Identifier’ defined in the option export sheet.
  3. Option Value Identifier: User defined unique identifier for the Option value. This field needs to be the same as the ‘Option Value Identifier’ defined in the Option Value export sheet.
  4. Lastly, save the prepared ‘Seller Product Options’ into your document folder.

III. SEO Data: It is easy to edit the title or image of one or two products available in sellers’ inventory. But with export seller inventory data bulk edits can be made into meta title, keywords, description, tags.

• Understanding Sequence Of Downloaded .csv To Import SEO Data: Open exported .csv file and once it is accessed, data can be viewed in the following sequence:
  
  1. Seller Product Id: User defined product identifier for the Product. This field needs to be the same as the ‘Seller Product Identifier’ defined in the Seller Product General Data sheet.
  2. Meta Title: User defined input field for the user to define Meta title for the product. Add/edit/update meta title with existing seller products.
  3. Meta Keywords: User defined input field for the user to define Meta keywords for the product.
  4. Meta Description: User defined input field for the user to define Meta Description for the product.
  5. Other Meta Tags: User defined input field for the user to define other Meta tags for the product.
  6. Lastly, save the prepared ‘Seller SEO Data’ content file into your document folder.

IV. Special Price: This option allows you to make bulk edits, add special pricesto exported seller's inventory products.

• Understanding Sequence Of Downloaded .csv: Open exported .csv file and once it is accessed, data can be viewed in the following sequence:
  
  1. Seller Product Id: User defined product identifier for the Product. This field needs to be the same as the ‘Seller Product Identifier’ defined in the Seller Product General Data sheet.
  2. Start Date: User defined date field to input the date from which the special price of the product starts from. Date format is mm/dd/yy.
  3. End Date: User defined date field to input the date from which the special price of the product ends. Date format is mm/dd/yy.
  4. Price: User defined field for special price of the product.
  5. Lastly, save the prepared ‘Special Price’ content file into your document folder.

V. Volume Discount: Growcer allows you to make bulk edits, add special discounts to the sellers products.

• Understanding Sequence Of Downloaded .csv: Open exported .csv file and once it is accessed, data can be viewed in the following sequence:
  
  1. Seller Product Id: User defined product identifier for the Product. This field needs to be the same as the ‘Seller Product Identifier’ defined in the Seller Product General Data sheet.
  2. Min Quantity: User defined field for minimum quantity of the product to be purchased for volume discount.
  3. Discount Percentage: User defined field for discount percentage to be applied to the product in case of the volume discount.
  4. Lastly, save the prepared ‘Volume Discount’ content file into your document folder.

VI Buy Together: Product bundles are used to sell two or more products in a store together at a discounted rate. Import/export, buy together products, add, manage, or remove offers for that particular product in bulk.

• Understanding Sequence Of Downloaded .csv: Open exported .csv file and once it is accessed, data can be viewed in the following sequence:
  
  1. Seller Product Id: User defined product identifier for the Product. This field needs to be the same as the ‘Seller Product Identifier’ defined in the Seller Product General Data sheet.
  2. Buy Together Seller Product Id: User defined product identifier for the buy together related Product. This field needs to be the same as the ‘Seller Product Identifier’ defined in the Seller Product General Data sheet.
  3. Lastly, save the prepared ‘Buy Together’ content file into your document folder.

VII Related Products: Group together related products through bulk managing data.

• Understanding Sequence Of Downloaded .csv: Open exported .csv file and once it is accessed, data can be viewed in the following sequence:
  
  1. Seller Product Id: User defined product identifier for the Product. This field needs to be the same as the ‘Seller Product Identifier’ defined in the Seller Product General Data sheet.
  2. Related Seller Product Id: User defined product identifier for the buy together related Product. This field needs to be the same as the ‘Seller Product Identifier’ defined in the Seller Product General Data sheet.
  3. Lastly, save the prepared ‘Related Products’ content file into your document folder.

2. Import Process

Once data is set up and ready to import, click ‘Import Export’ on the left navigation menu, select ‘Import’, from the displayed modular tab, select ‘Import’ and select ‘Seller Products’. The displayed modular tab contains the following information:

• Instructions: On this tab, read the ‘Data’ import instructions unique and specific to each option. A thorough review of the instructions is important so that importing errors can be avoided.
• Content: On this tab, the following information is prompted:
  • Language: Select language from the drop-down list. Please note that data preparation is language specific meaning if a file is prepared in English, language is selected as English and vice versa.
  • Select Data: Select ‘Data’ option from the provided drop down list. Please note selection of data is dependent on the exported data file and its preparation. Select relevant options:
    • General Data
    • Product Options
    • SEO Data
    • Special Price
    • Volume DIscount
    • Buy Together
    • Related Products
  • File To Be Uploaded: Click on the ‘Browse File(s)’, locate the file destination, click ‘Open ‘ and finally click on the ‘Submit’ button.

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. Go through the log file, mark the areas highlighted for error and re-import. In case a problem persists, contact team Growcer.