Guidelines for Bulk Upload of Catalog

Introduction

SmartBiz by Amazon is a one-stop shop for all online selling needs. Whether it is a small business, an entrepreneur, or a neighborhood store, everyone c
now create their own online store within minutes and start showcasing and selling their products online.

When a seller needs to use this sheet?

1. To create the catalog in bulk in one go.

2. To edit the current catalog in bulk.
(To edit or update the current catalog the brand will have to go to add --> Modify items in bulk, then download the current catalog and make
edits in bulk)

To start adding or editing products, go to "bulk_upload_sheet" tab which you can see at the bottom of your screen. You will s
various columns there for product details.
Please refer to the below instructions to update the columns in the "bulk_upload_sheet":
 Understanding the columns Instructions

Add the product name for each SKU (eg. T shirt or Notebook ). Character Limit:
Column C (Product Name)
100 -including spaces, special characters and numbers

List the maximum retail price of your product. It is mandatory to update

Column D (MRP)
this field. Enter numbers only. Cannot enter price <0

This is an optional field. Your selling price will always be equal to same or less than
Column E (Selling Price) the MRP. You can use this field to update the price at which you want to offer the
product for sale, especially when you are running any discount or promotional
offer.
Column F (Business Category) Select the business category from the dropdown to add products to the
reccomended section. Refer table below to see all available Business Category

This is a free text mandatory field. Accurate Product Category is necessary to

distinguish products in your catalog. Within each business category, you should
enter the most relevant product category in order to enable customers to easily
Column G (Product Category) navigate your store. Please remember not to create product categories with the
same name in different business categories.

Character Limit: 30 including spaces, special characters and numbers.E.g.: Gold

earrings, Trousers

Column H (Product Description) This is an optional field. You can choose to add a product description for
customers.
Character Limit: 1500 -including spaces, special characters and numbers
 Please select Parent from Dropdown in case you want to create variants
of this product. Please select Child if this is a variant of any product. Not
selecting any option will automatically mark is as a standalone product.
Eg. If you have a red shirt in 4 different sizes (S,M,L,XL), please mark the
first product as the Parent and the subsequent 3 products as Child.
Column I (Variant Relationship)
Kindly enter all the variants sequentially in rows so they are grouped
together.

Kindly note: Size/Color are mandatory for Parent & Child when creating
Variants

Column J (Size) This is free text. Enter Size as per your requirements. Kindly note it
would show on the product page in the same way as it is entered here.

Column K (Color)
Select colour from the dropdown list
Column L (Best Seller) Select Yes from the dropdown to mark a product as Bestseller. Only by marking
Yes would the product be tagged a bestseller and shown on storefront
accordingly.

Image can be added by uploading the link of that particular image in JPG/PNG
Column M (Product Image1) format in this column. Links can be generated by using this tool
-https://imgur.com/upload
This image would appear as the first photo on the Product Display Page. The max
image size can be 5 MB and the file format must be JPEG/PNG.

Image can be added by uploading the link of that particular image in JPG/PNG
Column N (Product Image2) format in this column. Links can be generated by using this tool
-https://imgur.com/upload
This image would appear as the second photo on the Product Display Page. The
max image size can be 5 MB and the file format must be JPEG/PNG.
 Image can be added by uploading the link of that particular image in JPG/PNG
Column O (Product Image3) format in this column. Links can be generated by using this tool
-https://imgur.com/upload
This image would appear as the third photo on the Product Display Page. The max
image size can be 5 MB and the file format must be JPEG/PNG.

Image can be added by uploading the link of that particular image in JPG/PNG
Column P (Product Image4) format in this column. Links can be generated by using this tool
-https://imgur.com/upload
This image would appear as the fourth photo on the Product Display Page. The
max image size can be 5 MB and the file format must be JPEG/PNG.

Image can be added by uploading the link of that particular image in JPG/PNG
Column Q (Product Image5) format in this column. Links can be generated by using this tool
-https://imgur.com/upload
This image would appear as the fifth photo on the Product Display Page. The max
image size can be 5 MB and the file format must be JPEG/PNG.

Image can be added by uploading the link of that particular image in JPG/PNG
Column R (Product Image6) format in this column. Links can be generated by using this tool
-https://imgur.com/upload
This image would appear as the sixth photo on the Product Display Page. The max
image size can be 5 MB and the file format must be JPEG/PNG.
1. Don't alter any of the column positions or names.The sheet Otheristhings to keep
to be used only in
to mind
add or edit the products. User cannot add a sheet or mov
positions of sheets
2. User cannot modify the instruction sheet
3. User cannot modify the column headers of the bulk_upload sheet
4. User
If you cannot
have insert questions,
any further a new column orwrite
please delete
to columns of the bulk_upload sheet
us at [email protected]

# Business Category
1 CLOTHING
2 FOOTWEAR
3 WATCHES
4 JEWELRY
5 LUGGAGE_AND_BAGS
6 BEAUTY_AND_PERSONAL_CARE
7 HOME_AND_KITCHEN
8 FOOD_AND_GROCERY
9 HOME_CARE
10 BOOKS_AND_STATIONARY
11 BABY
12 TOYS_AND_GAMES
13 ELECTRONICS
14 APPLIANCES
15 SPORTS_AND_FITNESS
16 FURNITURE
17 HEALTH_SUPPLEMENTS
18 LAWN_AND_GARDEN
19 PET_PRODUCTS
20 MULTIPURPOSE
21 GENERAL
 a neighborhood store, everyone can

d the current catalog and make the

m of your screen. You will see

 Mandatory/Optional

Mandatory

Mandatory

Optional
Mandatory

Mandatory

Optional
Optional

Optional

Optional
Optional

Optional

Optional
Optional

Optional

Optional

Optional
User cannot add a sheet or move
 MRP
SKU ID (Not to be Variant ID (Not to be Custom SKU (Optional) Product Name (Mandatory) Maximum 100
Edited) Edited) Maximum 30 characters characters (Mandatory)
Number only

Designer Jute Tote Bag for your daily needs | Shopping 1190
f4cf992a-36b3-4dbf-8e9c-49ca2a8c2ce0

Designer Jute Tote Bag for your daily needs | Shopping 1190
2ff84b0e-5d41-4ee6-a8a1-ec54a91a4c4c

Durga Mata Ji Print Jute Tote Bag(Full Size - Your gro 1190
81d3c63e-c1e5-4d6a-b586-ad9804078be3

Fashioned Jute Tote Bag Casual Color 1190

e626736b-5e60-4069-9998-78b8cbada187

Plain Jute Tote Bag - L Size - Your Lunch Box and offi 1190
cb5fce1a-bc0c-43d8-bddf-946fdf54c6c6

Plain Jute Tote Bag - M Size - Your Lunch Box and off 1190
b708ccf0-975f-4dd9-9ff2-cb1d7b9a0a96

Plain Jute Tote Bag - XL Size - Your Lunch Box and off 1190
c9e50559-7da3-4ff5-b60b-1982cd90951b

Strawberry Jute Shopping Tote Bag: Grocery Recom 1190

dae398b8-704a-400b-b3de-85c0c270af85
 Yoga Print Jute Tote Bag: Lunch Edition (L size : Can e 1190
01f32e46-e239-4dae-93bb-5ad9ea7d47ec
Selling Price (Optional) Business Category
Number only Should be (Mandatory) Select from Product Category (Mandatory)
less than MRP Dropdown

199 LUGGAGE_AND_BAGS Tote Bag, Handbags

199 LUGGAGE_AND_BAGS Tote Bag, Handbags

330 LUGGAGE_AND_BAGS Tote Bag, Handbags

330 LUGGAGE_AND_BAGS Tote Bag, Handbags

169 LUGGAGE_AND_BAGS Tote Bag, Handbags

149 LUGGAGE_AND_BAGS Tote Bag, Handbags

169 LUGGAGE_AND_BAGS Tote Bag, Handbags

230 LUGGAGE_AND_BAGS Tote Bag, Handbags

199 LUGGAGE_AND_BAGS Tote Bag, Handbags
 Variant
Best Seller
Product Description (Optional) Maximum 1500 characters Relationship Size (Optional) Colour (Optional)
(Optional)
(Optional)

Designer Jute Tote Bag for your daily needs | Shopping Bag
L(14"x12"x5") #125592_Blue Yes
| Grocery Bag | Gifting Bag | (L size)

Designer Jute Tote Bag for your daily needs | Shopping Bag
XL(16"x14"x5") #125592_Blue Yes
| Grocery Bag | Gifting Bag | (XL size)

Durga Mata Ji Print Jute Tote Bag(Full Size - Your grocery

XXL(17"x15"x5") #4186C4_Steel_Blue Yes
Partner)

Fashioned Jute Tote Bag Casual Color L(14"x12"x5") #D7D7D7_Light_Gray Yes

Plain Jute Tote Bag - L Size - Your Lunch Box and office
L(12"x14"x4") #FEE49E_Yellow Yes
Buddy

Plain Jute Tote Bag - M Size - Your Lunch Box and office
M(10"x12"x4") #FEE49E_Yellow Yes
Buddy

Plain Jute Tote Bag - XL Size - Your Lunch Box and office
XL(14"x16"x4") #FEE49E_Yellow Yes
Buddy

Strawberry Jute Shopping Tote Bag: Grocery Recommended L(14"x12"x5") #CA0813_Red Yes
Yoga Print Jute Tote Bag: Lunch Edition (L size : Can easily fit
L(12"x14"x4") #FD9927_Deep_Saffron Yes
your lunch box and a water bottle)
Product Image1 (Optional) Product Image2 (Optional) Product Image3 (Optional) Product Image4 (Optional) Product Image5 (Optional)

https://m.media-amazon.co https://m.media-amazon.comhttps://m.media-amazon.com/ihttps://m.media-amazon.comhttps://m.media-amazon.com

https://m.media-amazon.co https://m.media-amazon.comhttps://m.media-amazon.com/ihttps://m.media-amazon.comhttps://m.media-amazon.com

https://m.media-amazon.co https://m.media-amazon.comhttps://m.media-amazon.com/https://m.media-amazon.comhttps://m.media-amazon.com/images/I/81evM

https://m.media-amazon.co https://m.media-amazon.co https://m.media-amazon.com/ihttps://m.media-amazon.com/https://m.media-amazon.com

https://m.media-amazon.com
https://m.media-amazon.comhttps://m.media-amazon.com/https://m.media-amazon.com/images/I/81NzqGrQAKL._SX679_.jpg

https://m.media-amazon.com
https://m.media-amazon.comhttps://m.media-amazon.com/https://m.media-amazon.com/images/I/81NzqGrQAKL._SX679_.jpg

https://m.media-amazon.com
https://m.media-amazon.comhttps://m.media-amazon.com/https://m.media-amazon.com/images/I/81NzqGrQAKL._SX679_.jpg

https://m.media-amazon.co https://m.media-amazon.comhttps://m.media-amazon.com/https://m.media-amazon.comhttps://m.media-amazon.co
https://m.media-amazon.co https://m.media-amazon.comhttps://m.media-amazon.com/ihttps://m.media-amazon.comhttps://m.media-amazon.com
 Product Image6 (Optional)

https://m.media-amazon.com/images/I/71wq19SV69L._SX679_.jpg

https://m.media-amazon.com/images/I/71wq19SV69L._SX679_.jpg

-amazon.com/images/I/81evMK5KG2L._SX679_.jpg

https://m.media-amazon.com/images/I/8124mzOsVVL._SY675_.jpg

qGrQAKL._SX679_.jpg

qGrQAKL._SX679_.jpg

qGrQAKL._SX679_.jpg

https://m.media-amazon.com/images/I/51zvPkH549L._SX679_.jpg
https://m.media-amazon.com/images/I/81GcWzwiXoL._SX679_.jpg