How To Mass Create Products On Seller Center

MASS PRODUCT CREATION via .csv OR .xslx

mass_create

 

Working on the Mass Product Creation Template is quite easy. As you can see, all the information that is on the template is the same information that Seller Center requests from you when creating products manually product by product. The template when downloaded is on a Microsoft Excel (.xslx) Sheet and you can add as many products/sizes as you want but keep in mind that the upload template should only have not more than 3000 products for better processing on Seller Center.

 

mass_create_1

 

Tabs 1 & 2 (Introduction & Data Terminology) have information about the use of the template. Tabs 3 & 4 (Upload Template & Valid Values) are the ABSOLUTELY REQUIRED sheets. In Tab 3 (Upload Template) , you can find all information necessary for creating your product. In Tab 4 (Valid Values) you can find all the Valid Values of the template.

WHAT IS A VALID VALUE?

On some columns on the template you can only input information already approved, active and visible on the system like Brand, Size/Variation, MaterialFamilyColor etc.

These are important in Product Creation, most especially Brand and Size/Variation.

mass_create_2

Please fill up every column with the same structure and indication as if you were filling up attributes while creating products manually on Seller Center.

 

MAIN INFORMATION ON THE TEMPLATE

 

N.B Information required is subject to category selected.

mass_create_3

  • Product Name*: Basically Product Name PLUS Model (Where Applicable) PLUS Colour.
  • Brand*: Remember that if a brand is not on Seller Center you won’t be able to select the brand. On Tab 4 “Valid Values”, on the “B Column”, you will find all brands created/active/visible in Seller Center, please look for your brand there. If the brand is not created, please fill this Brand Request Form.
  • Product Description*: Has to be written in plain text or in .HTML codes. Click Here To Learn How To Create .HTML Codes. You can also access .HTML Code for your products on Seller Center by simply clicking on the icon on the extreme left after inputting your Product Description;

 

mass_create_4

mass_create_5

Short Description/Highlights*: Must be written in bullet points so you would need to write them down with .HTML Codes. Click Here To Learn How To Create .HTML Codes. You can also access .HTML Code for your products on Seller Center by simply clicking on the icon on the extreme left after inputting your Highlights/Short Description;

mass_create_6

mass_create_7
CATEGORIZATION

Primary Category* is mandatory.

All the same rules to choosing categories on Seller Center apply here. Please remember the following points;

  • The main category is formed by the first two levels of categories and all the subcategories are formed by the following levels.
  • Once a Main Category has been chosen as a sub-category, it is not possible to choose another Main Category.
  • After choosing a Main Category all sub-categories need to belong to that category, you cannot choose subcategories from another Main Category.

Go to the Tab 4 (Valid Values) and on the Column D you will find all the main categories and sub-categories for that template. Remember, Seller Center templates are by category, So you would not find a sports category on electronics template.

Look for the category of your product by selecting the category desired from the drop down or copy the cell and then paste it on the template. Choose the same way the Additional Categories.

Remember you can choose up to 3 Additional Categories

N.B When you are done inputting the data on the sheet, copy & paste values on a new sheet. Under Primary Category & Additional Categories, Delete the alphabetical representation of the category & leave only the numerical representation ie “- Groceries /…”

Example;

2842 – Groceries / Laundry & Homecare / Laundry / Powders > You are deleting ONLY the characters in BOLD

 

mass_create_8

mass_create_9

mass_create_10

PRODUCT PRICING

mass_create_11

They are the same format as on Seller Center:

  • Price*: Normal Price.
  • Sale Price: Price With Discount
  • Sale Date: Start Date and End Date of the discount, it MUST be in an YYYYMMDD HR:MIN:SEC format.

 

VARIATION

  • Seller SKU*: For your own reference, please remember all restrictions on SKUs: One Seller Sku per product
  • Parent SKU: Used ONLY in Fashion; Apparel and in Shoes. Parent SKU links a group of Seller SKU’s with the same model but different sizes. The parent SKU can only link different sizes not different colors. The smallest size Seller SKU is the Parent SKU, so we advise you to create all the size together even if you do not have stock in some, that way they will appear in the same publication.
  • Variation*: is used to identify the size of the Seller Sku. Variations are all possible sizes that a SKU can have. We advise you to put all sizes according to your actual assortment because that way Costumers can make better purchases.
  • Product Id: Can be a UPC, EAN or ISBN. (Use only where applicable)
  • Quantity*: Stock per Seller Sku

mass_create_12

 

PRODUCT SPECIFICATIONS

mass_create_13

  • Product Line: Product Line is the Seller Name
  • Color Family: Refers to the family of the color of the product. There is a drop down selection for this field.
  • Material Family: Refers to the family of the main material of the product. There is a drop down for this field.
  • Main Material: Refers to the most dominant material of the product eg Rubber, Cotton, Lycra, Plastic, Silicon etc

 

PRODUCT DESCRIPTION

mass_create_14

  • SEO Index: Index
  • NAFDAC No: Where Applicable (Health & Beauty, Groceries)
  • Youtube Id: Please Add your Youtube Video ID here e.g. http://www.youtube.com/watch?v=htlgaXRAe2k ID is: htlgaXRAe2k
  • Description:  The product description should give the customer useful information about the product to ensure a purchase.
  • Short Description: Provide short major highlights of the product, to make the purchase decision for the customer easier. Always in bullet points.
  • Package Content: Short summary/list of the package content, which the customer gets.
  • Note: Possibility to enter some comments or additional information about the product

 

MEASUREMENTS;

mass_create_15

 

  • Product Measures: Measurement of the product; Dimensions (Length x Width x Height in cm)
  • Product Weight: Weight of the product. The unit for measuring should be specifically in Kilograms (If weight is in Grams convert in Kilograms). Enter only numeric value of weight. eg if product is 1KG, enter as 1, if product is less than 1KG, say 100g, enter as 0.1

ADDITIONAL PRODUCT ATTRIBUTES;

mass_create_16

  • Product Warranty: Provide the warranty validity period eg. 1 Year, N/A (When No Warranty). Most applicable to General Merchandise products
  • Warranty Type: Service Center, Repair by Vendor, Replacement By Vendor. Drop down available for this field. Only applicable when Product Warranty is filled
  • Warranty Address:  Enter the Service Centre Address. Only applicable when Product Warranty & Warranty Address is filled
  • Certifications: Select different certifications that the product owns, or with which certifications the product was marked.  Where Applicable. Drop down available for this field
  • Production Country: Where the product was made/produced/manufactured

 

JUMIA LOCAL

Jumia Local: If your product is made/assembled in Nigeria, you can validate your claim by sending an email to seller-support@jumia.com.ng or calling us on 01-8881102 to be part of the Jumia Local initiative before you tick this box to add it to the Jumia Local program. By ticking this box, you are agreeing to the Jumia Local Terms & Conditions.

mass_create_17

 

TEXT MANUFACTURERS;

  • Manufacturer TextPossibility to add some information from the manufacturer about the product. Only where applicable
  • Care Label: Enter information about the care of the product, provided by the manufacturer. Only where applicable.

mass_create_18

IMAGES

mass_create_19

In the template, contrary to creating manually on Seller Center, all images must be on their URL address, but besides that, all the other features must remain.

Please remember:

  • Minimum Image Dimensions are 680 x 850 megapixels and Maximum 2000 x 2000 megapixels. All pictures must be on a white background with no Watermarks or scribbles.
  • Minimum of 1 product image with a maximum of 8 is required to successfully create a product
  • If you do not have your pictures in URL’s, you can upload and generate URL’s for them by using this link; http://postimage.org/

.csv FILE CREATION

Remember that Seller Center only accepts .csv & .xlsx file formats, so once you have complete your Template for Product Creation and you want save in .csv, you must make it a .csv file with a encoding UTF-8.
Please copy all the information on your template and paste it on a Notepad, save it with any name as you want but with the .csv extension and a UTF-8 encoding.

mass_create_20

mass_create_21

SAVING IN .xlsx;

mass_create_22


CREATION PRODUCT TEMPLATE UPLOAD

Once you have your .xslx or .csv file, go to Product and then click on Import Products.

mass_create_23

mass_create_24

 

After that, on “Import Products”, select “Create new products” and browse for your .csv file, click on “Accept” and then on “Upload File”.

mass_create_25

mass_create_26

When there is no immediate problem/issue on the upload, there will appear a green message telling you about the success of the upload and you will find it on final status of the upload in feeds with a check mark or with error report.

 

mass_create_27

 

UPLOAD ERRORS

If the upload is not successful at the initially, a blue message will appear at the top, to see the error you could wait to have the full report or you could see the preview. Click on “Show Preview

If the upload is not successful at the initially, a blue message will appear at the top, to see the error you could wait to have the full report or you could see the preview. Click on “Show Preview

 

mass_create_28

Common Error Examples;

  • Date Format: Remember it should be YYYYMMDD HR:MIN:SEC

mass_create_30

  • Field Names: All fields on the template cannot change and are case sensitive. For example, Brand should stay as “Brand” It cannot change to “Brand1” or even “Brands

mass_create_29

  • Uploading an unsupported file format (not .csv or .xslx)

mass_create_31

  • When Upload File is not saved with a UTF-8 encoding (For .csv only): When the upload file is initially successful but there is a mistake for one or all the products, there will be an “x” on it and a link to download a report. This report will tell you where exactly the mistake was. Click on the link and open the file. It will be a .csv file where you will be able to see the mistake. The important column is the “A”, there is specified the mistake and on column “C” you can find the SKU that have the mistake.

mass_create_32

Fix the error on the creation product template, copy it and paste it on a Notepad, save it as a .csv file with encoding UTF-8 and upload again.

 

 

Advertisements