How can I create products in bulk?

In this section of the Seller Center manual, you will learn how to upload your products in bulk. This method is recommended when you have a large product catalog.

Mass product upload is a quick and easy way to add your SKUs to the Seller Center platform. This is done using an Excel template.

In case you need to remember something, here is a step-by-step guide.

STEP 1: SELECT THE CATALOG MODULE

• Then, select the PRODUCT IN BULK UPLOAD module.

STEP 2: SELECT A CATEGORY

When you click on the category field, a pop-up window will open where you can search the category of the product you are creating. You can find it using the search engine or  clicking on ROOT and browsing the categories available. Select the category that best suits your products (you can choose a parent category or a subcategory). This category is used to complete attributes, but it is not the category in which your products will appear on the e-commerce. Each company has different categories, so we are responsible for placing your products in the category they correspond best.

STEP 3: DOWNLOAD THE EXCEL TEMPLATE

Select  "Get product upload form," and an Excel file will be downloaded.

STEP 4: START WOKING ON THE EXCEL TEMPLATE

Once the template is downloaded, fill in the information. Black cells are mandatory. Yellow cells are the data sheet fields.

STEP 5: HOW TO FILL IN THE TEMPLATE FIELDS

Once you have read the template headings, you can start filling them in. Here are some tips to avoid any mistakes so that the file can be processed quickly:

• Product ID column must always be left empty.
• SKU column must always be left empty.
• Product Name column: This is the product name that will be displayed on the web. This field must be filled in following certain parameters, otherwise the content team will not be able to activate it. The way to name the products is as follows: Product Type + Brand + Model + Outstanding Feature. For example: Cell Phone Samsung Galaxy A50 64GB BLUE / Quilt Aquarela Primavera Double.
• SKU Name column: Here you must enter exactly the same you entered in the previous column (Product Name). It is important to enter exactly the same.

• Product Description column: The description field must be filled in with clear and coherent information because this information will be displayed on the websites. Be very careful regarding spelling and coherence. In this field, it is recommended to use an engaging product description. This field answers the following questions: What is the product? Why should people buy it? Other more technical details are to be completed in the "Specifications" section.

• The product brand is placed in the Brand column; which needs to have been previously created by IR DIGITAL's content team.  The brand must be spelled exactly the same as when it was created in the system. Therefore, it must always be written in CAPITAL LETTERS. For example: BOSE.
• In the UPC column, enter the EAN code, also known as Universal Product Code or barcode. If you do not have this information, you can enter a number to identify your products. This entry can only be numeric and must have more than 6 digits. Also, avoid common or easy numbers. Failure to do so will result in product rejection. Keep in mind that this data cannot be edited once it has been submitted.
• In the Price column, enter the product's normal price (original price).

• In the Discounted Price column, enter the price with any promotion or discount that the product may have. (This field is not required in case the product does not have a current promotion).
• In the Price End Date column, enter the end date of the promotion. This date must be entered in year - month - day format. If you do not know how to enter it in this format, right click on the column, then click on cell format, then "date", and select the year - month - day format.

• In the Image URL column, enter the links of the product image. Make sure the images at these URL addresses are in JPG or PNG format. Use the following symbol to separate the images: "|", without leaving spaces. If you do not know where to convert your photos into URL addresses, we recommend that you use our image manager: https://images.Seller Center.pe/list-image

• The HEIGHT, LENGTH, WEIGHT, WIDTH columns must be filled in with data from the package measurements. Height, length, and width are stated in centimeters. The weight is stated in grams. It is important to state them in these units because this is the basis for calculating the shipping price to be charged to the customer. Do not include numbers with decimals. Always use whole numbers.
• In the SITES column, fill in Promart|Oechsle|Plaza Vea|RealPlaza (if the product goes to all four sites) or Promart|Oechsle, Oechsle|Plaza Vea, Promart|Plaza Vea, Promart|RealPlaza, Plaza Vea|RealPlaza, Oechsle|RealPlaza; it is important to fill data in as shown here, otherwise the file will not be processed.

• All yellow cells are the specification fields (data sheet). These fields are not mandatory, but it is recommended to fill in at least 80% of them. Remember that the data sheet is a key factor in the purchasing decision. Products that do not have a datasheet are usually seen as not very trustworthy.

STEP 6: CHECK ALL FIELDS

When you have finished completing the fields, make sure to check the information recorded because small mistakes may cause the file to fail to process. Review the above instructions carefully to avoid this type of issues.

• Make sure not to leave required cells empty.
• Do not format cells in any way (do not center, do not adjust text, do not apply bold, italics, etc.).
• Do not use cells with formulas.
• Do not use characters such as "&", "#", or others.
• A common reason for SKUs failing to be created is that the brand is not written the same is registered in the system. Check this and ask about it through the support channel in the Seller Center.
• Do not use filters when processing the file.
• Do not delete any columns.
• Do not add columns.
• Use whole numbers in the product measures. Do not use commas.
• Do not leave spaces between the URLs of the images.
• The validity dates for the discount must not have expired.

STEP 7: UPLOAD FILE TO THE SELLER CENTER

Save the file and select it in the Seller Center. If everything is OK, no warnings will appear. Click on process file and confirm action. Next, go to "Product Manager" to check if they were successfully created.

If there are any errors, the system will display a red warning indicating what you need to correct for the file to be processed.

STEP 8: CHECK UPLOADED PRODUCTS

Make sure the products have been successfully created in the product manager and wait for approval from the content team. It is recommended to send a ticket through the support channel to get the SKU activation to be processed

We hope this was helpful!