How to add products in bulk using CSV
In this article, we will discuss how to bulk upload products using a CSV.
Marketcube provides multiple ways to add new products. If a user wants to upload multiple products in one go to save time and effort, they can opt for the bulk upload of products using CSV. Now, the question arises that what is a CSV file and how does it work?
What is a CSV file?
CSV stands for comma-separated values, a file format (.csv) for spreadsheets. You can use CSV files to import and export products, customers, orders (export only), and discounts (export only). They can be useful in many situations, such as switching to Marketcube from another marketplace platform or uploading products by using a spreadsheet.CSV files might seem intimidating at first, but after you understand their format and how they work, you might decide to use them for a variety of tasks.
Products are an indispensable part of a marketplace. One of the ways to add a product is by using the product CSV. Operators and vendors both can add the products using a form that contains sections like product title, description, variants, price, etc. but one by one. This is a long and tedious process. To overcome the same and save some time & effort we came with a solution known as bulk upload products using CSV.
Steps to add products using the CSV from the Operator's Marketcube account:
- Log into your Marketcube account.
- Click on the Products tab. Click on the 'Add Products' under the Actions tab on the right-hand side.
- From drop down click on "Add products in bulk using a CSV".
You can now see the option to D ownload the sample CSV.
Please Note: Only Marketcube's Sample CSV can be used to upload the products.
Once filled out your CSV with your Product details upload the CSV under the same dropdown heading. Click Add file >> Select the CSV file >> Click the Upload button.
Once downloaded make sure to fill in all the fields with your product details. To see more details on each CSV section refer to the below-mentioned details for each field respectively.
Your Products will be added to your account and depending on your operator's settings might be visible to customers straight away or post their approval.
Product CSV file format
The first line of your product CSV needs to include the field headers described in the table, in the same order, each separated by a comma. Subsequent lines in the file should contain data for your product using the same fields in that exact same order.
Handles are unique names for each product. They can contain letters, dashes, and numbers, but no spaces. A handle is used in the URL for each product. For example, the handle for a "Women's Snowboard" should be womens-snowboard, and the product's URL would be https://yourstore.myshopify.com/products/womens-snowboard. Every line in the CSV that starts with a different handle is treated as a new product. To add multiple images to a product, you should add multiple lines with the same handle.
The title of your product. Example: Women's Snowboard
- Body (HTML)
The description of the product is in HTML format. This can also be plain text without any formatting.
- Vendor (min. 2 characters)
The name of the vendor for your product. For example, John's Apparel. For Marketcube to process CSV upload correctly you need to ensure the vendor you're uploading products for has been created in your Marketcube marketplace.
The product type. For example, Snowboard.
- Tags (can be left blank)
A comma-separated list of tags is used to tag the product. Most spreadsheet applications automatically add quotes around the tags for you. If you are using a plain text editor, then you need to manually add the quotes. For example, "tag1, tag2, tag3".
- Collection (can be left blank)
Need to update the same.
States whether a product is published on your online store. Valid values are TRUE if the product is published on your online store, or FALSE if the product is hidden from your online store. Leaving the field blank will publish the product.
- Option1 Name
If a product has an option, then enter its name. For example, Color. For products with only a single option, this should be set to Title.
- Option1 Value
If a product has an option, then enter its value. For example, Black. For products with only a single option, this should be set to Default Title.
- Option2 Name (can be left blank)
If a product has a second option, then enter its name. For example, Size.
- Option2 Value (can be left blank)
If a product has a second option, then enter its value. For example, Large.
- Option3 Name (can be left blank)
If a product has a third option, then enter its name.
- Option3 Value (can be left blank)
If a product has a third option, then enter its value.
- Variant SKU (can be left blank)
The SKU of the product or variant. This is used to track inventory with inventory tracking services. This field can't be left blank if you're using a custom fulfilment service.
- Variant Grams
The weight of the product or variant in grams. Do not specify a unit of measurement or use decimals. For example, for a weight of 5.125 kg, enter 5125. Shopify always imports and exports the weight in grams, even if you specify a different unit. You must use accurate weights if you intend to offer carrier-calculated shipping or use a third-party fulfilment service.
- Variant Inventory Tracker (can be left blank)
Include your inventory tracking for this variant or product. Valid value will be Shopify or blank if inventory is not tracked.
- Variant Inventory Quantity
The number of items you have in stock of this product or variant.
- Variant Inventory Policy
How to handle orders when inventory level for this product or variant has reached zero. Valid values are denied or continue. deny will stop selling when inventory reaches 0, and continue will allow sales to continue into negative inventory levels.
- Variant Price
The price of the product or variant. Don't place any currency symbol there. For example, 9.99.
- Variant Compare at Price
The "Compare at Price" of the product or variant. Don't place any currency symbol there. For example, 9.99.
- Variant Requires Shipping (blank = FALSE)
The option requires shipping. Valid values are TRUE, FALSE, or blank.
- Variant Taxable (blank = FALSE)
Apply taxes to this variant. Valid values are TRUE, FALSE, or blank.
- Variant Barcode (can be left blank)
The barcode, ISBN, or UPC of the product.
- Image Src
Enter the URL for the product image. Shopify downloads the images during the import and re-uploads them into your store. These images are not variant-specific. The variant image column is where you specify variant images. You can't change the image filename after that image has been uploaded to your store. Don't upload images that have _thumb, _small, or _medium suffixes in their names.
- Image Alt Text (can be left blank)
Alt (alternate) text describes an image and is an important part of a product description. If an image can't load for any reason, then alt text is shown instead. It's also used by assistive technology to describe an image to a customer who's visually impaired. Including alt text will boost your website's SEO. Keep your alt text brief and descriptive. The maximum length is 512 characters, but 125 or less is recommended.
- Gift Card
States whether the product is a gift card or not. Valid values are TRUE, or FALSE. The addition of this column also allows you to edit other gift card details, such as the Body or Tags columns, and import these changes. A gift card can be created and activated only in the Shopify admin. You can't initially create a gift card through a product CSV import.
- Variant Image
The URL for images of variants. Variant Weight Unit Valid values are lb, kg, and oz. Variant Tax Code SHOPIFY PLUS The Avalara code to apply taxes to this product. This field applies only when you are importing to or exporting from a store that uses Shopify Plus's integration with Avalara AvaTax. When you create a CSV file by exporting products from a store that uses Avalara, the Variant Tax Code field is populated. If you import this CSV file into a store that doesn't have Avalara set up, then your import will fail.
- Google Shop-Ads, SEO title, etc.
These fields are not mandatory and can be left blank. Only fill these in if you want information for Google feeds and SEO to be populated via CSV upload. If you prefer you can add and edit this information manually for each product afterwards.
Got more questions? Use the chatbox on the right side of your window to get in touch with us or email us at ‘firstname.lastname@example.org’.