<img src="abc.png" />
    
call to replace anchor tags contains '/admin' in href

Product CSV file format

A CSV is a comma separated values file, which allows data to be saved in a table structured format. You can use this file to upload products in bulk at the StoreHippo backend.

You need to prepare the CSV file in correct format before you can start importing products. Download a sample CSV file from the imports section in products. The first row of your CSV has to include all the fields as given in the sample CSV and should be in the exact same order. The data which you enter for products should be in accordance with the fields given.

File format

StoreHippo accepts the CSV file format only to import the products in bulk. Prepare the CSV file in the correct format. Download a sample CSV file from the imports section in products. The first row of your CSV includes all the fields as given in the sample CSV and should be in the exact same order. The data which you enter for products should be in accordance with the fields mentioned. A typical CSV file looks like shown below:


CSV Fields

_id

_id is a unique id generated for each product automatically once the product is uploaded. Keep this field blank when adding new products. Also while using the CSV file for updating existing products, this field will be used to identify the product to be updated.

Name

Write the name of the product by which it will be available on thestore front. For eg: Cotton T-shirt.

Alias

Alias is the unique name for each product which gets created automatically once the product is uploaded. It can contain letters, dashes, and numbers, but no spaces. Aliases used in the URL for each product. Keep this field blank when adding new products.

Description

Write the description of the product. HTML can be used to format the description in a particular format.

Price

Write the price of the product, it is the selling price of the product at which you want to sell the product. Use numerics only in the field.

Compare Price

Compare price can be the listing price of the product. If the product is being sold at a discount you can add the higher amount in the compare price section whereas the price would be the amount at which the product would be actually sold. Use numerics only in the field.

Collections

Provide the name of the collection that you want to associate the product with.

Brand

Provide the name of the brand that you want to associate the product with.

SKU

SKU (Stock Keeping Unit) is the unique code which helps in identifying the products and keep track of inventory.

Barcode

Provide the barcode of the product if any.

Categories

Provide the name of the category and subcategory in which you want to place the product.

For example: If the category tree is as given below

  • Clothing
    • Women
      • Tees

Then the category, subcategory, and sub-subcategory would be defined as shown below:

clothing, clothing: women, clothing: women: tees

Publish

If you want the product to be visibleonthe storefront, write "1". If you want to upload the products at the backend in the unpublished list, write "0".

Weight

Provide the weight of the product which is after the packaging is doneasthis weight is used by logistics to pick the product. The weight of the product by default is in grams. (Note: Please enter numbers only in the field.)

Tax

This field can be left blank as tax and its settings are controlledfrombackend directly.

Sort_Order

Sort order is used to define the order of product by providing each product a number.

Attributes

You can define multiple attributes if required. For more details please refer Product Attributes

Inventory management

Write "automatic" if you want StoreHippo to track product inventory. Write "none" if you don’t want StoreHippo to track product inventory.

Product has multiple variants

Write "1" if the product has multiple variants or you can leave this field blank.

Inventory management level

Write "variant" if the product has any variation that customer can choose from. Write "product" if it’s a single product without any variation.

Inventory allows out of stock

Write"1" if you want the customer to be able to place an order even if the product is out of stock, if not then place "0".

Inventory quantity

Provide the quantity of product available to sell.

Inventory low stock quantity

Provide the quantity of product at which you want to get notified so that you can fill the stock again.

Option set

Give a name to option set for backend purpose.

  • Option1 name: Provide the name of the first product option. 
  • Option1 value: Provide the option value.  
Note: You can create multiple options set in a similar way by just adding another column changing the numeric value in the field. For example, to create a second option set you can add option2_name, option2_value columns in the CSV.

Variant tag

Provide the exact image tag of the image that you want to associate with the variant.

SEO title

Write the SEO title.

SEO description

Write the SEO description.

SEO keywords

Write SEO keywords.

Image1

Enter the URL of the first image. If files are uploaded to Files section of your store then you can use the relative path to your images. Refer to Preparing Images for the CSV file for more details.

If there are multiple images then repeat the image columns e.g. image1, image2, image3.

Image1 caption

Provide a caption for image.

Image1 tags

Write the tag to be associated with the variant.

Sub stores

Provide thesub storesfor your products.


Additional columns that can be added in CSV

max_limit_to_buy_this_product

You can control the maximum limit for users to purchase the product.

min_limit_to_buy_this_product

You can control the minimum limit for users to purchase the product.

DELETE

This column can be added in the CSV file to delete products in bulk. Once the column title is added, you need to mention DELETE in the respective rows of products/variants that are to be deleted. After adding the column import the CSV file, to process bulk deletion.

Note: Using this command you can either delete the entire product or entire variant, but cannot delete specific sections of the product.