Which products can you create using this method

To create a large quantity of products at once, there is nothing better than using the bulk product creation template. This template allows you to use an Excel sheet to create as many products as you wish.
Follow this step-by-step guide to learn how to do that.

Steps to start creating and uploading new products massively

• Where to find the upload form

A: Connect to your account on the seller center, then click on Products → Import Products

B: Select the template for the product category you want to create

C: Then choose the “Exports” section and download the required template
After downloading the file as a Microsoft Excel (.xslx) file, you can add any number of products/sizes you want. Please note that the file you upload should not exceed 3000 products.

• How to proceed with mass product creation using the template

A: Section 1 “Introduction” contains information about how to use the form. Follow the instructions to make sure that your file is approved by our team.
B: Section 2 “Upload Template” is the template you wish to upload/download
– For each product you wish to create, please fill each column/section, as if you were filling in the data for the product creation manually (one by one) on the seller center.
Please note that in some sections of the form, you will be required to use the option provided in the dropdown menu as shown in the image below.

• C: Key Information

– Product Name*: The product name, followed by the model (If available), followed by the color.
– Brand*:Please search for your brand in the seller center. You will find all the created/active/visible brands listed.
Remember that if the brand is not listed, you won’t be able to specify the brand, in such case please “raise a claim” to initiate new brand creation request.
– Product Description*: Must be written in normal text (paragraph)
– Key Features*: Must be written in form of bullet points

• D/ Categorization

Move to the “Categories” sheet to find all the primary and sub categories available for this template.
Remember that the template differs according to the category (which means you won’t find the Sports category under the Electronic Products template)
Search for the category of your product by selecting the required category from the list or copy the fields then paste it onto the template.

• E/ Product Pricing

The same format shown on the seller center
– Price*: Regular Price
– Discount Price: Price after discount
– Selling date: The beginning and end date of the discount, must be in this format year-month-day; hour-minute-second

• F/ Variety

– Supplier SKU*: One unique seller SKU per product per variation.                                                                                           – ProductID: GTIN code Could be (ISBN or EAN or UPC) from GS1 .If you don’t have a GTIN code get it from GS1 Egypt from here.
– Parent SKU : Mainly used for fashion clothing and footwear products. The Parent SKU groups a number of SKUs for the same model (same color) but with different sizes.
The Parent SKU does not group different colors.
We recommend that you create all sizes together even if you don’t have available stock at this moment, this way all the codes will appear under the same parent SKU.
– Variation*: Used to determine SKU size Variation/difference in all sizes available for the SKU. We recommend that you add all sizes according to the actual categorization to guarantee a better buying process for the client.
– Quantity*: Stock for each SKU

• G/ Product Specifications

– Product Origin/Producer: will be the seller name if you are the manufacturer for the product you are selling.
– Color Family: Refers to the color range of the product.
– Materials collection: Refers to the material range of the product.
-Main material: Refers to the predominant materials for the product like rubber, cotton, lycra, plastic, silicone, etc

• H/ Product Description

– SEO Guide: Guide
–NAFDAC – Number: In case of necessity (Health and beauty, Grocery)
– YouTube ID: Adding YouTube video link ID example http://www.youtube.com/watch?v=htlgaXRAe2k ID is: htlgaXRAe2k
– Description: Product description should provide the client with valid information about the product to initiate guarantee the buying process.
– Key features: Provide a brief description of the product to make the buying process easier for the client. Must be written in bullet points.
– Package content: includes the package contents your client will be receiving.
– NB: The option to add some additional comments or information about the product

• I/Measurements

– Product Size: Product dimensions (Width x Height x Depth in cm)
– Product Weight: The unit of measurement for product weight must be in kilograms (please convert the weight to kilograms if it is in grams) only enter the numeric value of the weight. Example: If the product is 1 kilogram, write the number 1. And if the product is less than 1 kilogram, write 0.1

• J/ Additional features of the product

– Product Warranty: Providing product validity period. Example: One year or writing N/A (when there is no warranty)
– Warranty type: Maintenance Service Center, Repair by Vendor, Exchange by Vendor. Valid if the product has warranty
– Warranty Address: Valid if the product has warranty
– Credits/Certificates: Specify the different certificates that the product has if applicable.
– Country of Manufacture: Where the product is being manufactured

• K/About the Producing Companies

– About the producing company You can add some information about the producing company if applicable
– Product care information Enter information about product care instructions from the manufacturer if applicable

• L/ Photos

The photos must be added to the form, unlike manual product creation on the seller center with a URL, otherwise, all properties remain the same.
– If you do not have photos with URL, you can upload and create a URL for them using this link http://postimage.org

• M/ Save the file

– Please remember that the seller center only accepts the temple in the following file formats: .xlsx and .csv

• Completing the addition of a large group of products

A: Once you have the .xslx or .csv template file ready, go to “Products” and click on “Import Products”

B: Then click on “Upload your File” in “Import Mode”, select “Create New Products” then choose the .csv or .xlsx file and click on “Open”, then click “Upload file”

• Examples of Frequently Made Mistakes

– Date Format: Remember it should be year-month-day hour-minute-second
– Section Name (Header): All section names (header) must not be changed. For example, the brand should remain named “Brand” and not changed to “Brand 1” or even “The Brand”
–Uploading an unsupported file format (Not .csv or .xslx)