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.
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:
_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.
Write the name of the product by which it will be available on thestore front. For eg: Cotton T-shirt.
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.
Write the description of the product. HTML can be used to format the description in a particular format.
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 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.
Provide the name of the collection that you want to associate the product with.
Provide the name of the brand that you want to associate the product with.
SKU (Stock Keeping Unit) is the unique code which helps in identifying the products and keep track of inventory.
Provide the barcode of the product if any.
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
Then the category, subcategory, and sub-subcategory would be defined as shown below:
clothing, clothing: women, clothing: women: tees
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".
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.)
This field can be left blank as tax and its settings are controlledfrombackend directly.
Sort order is used to define the order of product by providing each product a number.
You can define multiple attributes if required. For more details please refer Product Attributes
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".
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.
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.
Provide the exact image tag of the image that you want to associate with the variant.
Write the SEO title.
Write the SEO description.
Write SEO keywords.
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.
Provide a caption for image.
Write the tag to be associated with the variant.
Provide thesub storesfor your products.
Additional columns that can be added in CSV
You can control the maximum limit for users to purchase the product.
You can control the minimum limit for users to purchase the product.
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.