Import Product Information using Excel

Modified on Thu, 30 May 2024 at 03:52 PM

Pre-requisites

Before adding product information to ProStudio you must make sure that all the product attributes has been defined that is required in the product listing.


To add Fields in the product listing, please see Add Product Attributes


Import information

Below is the procedure to import product information to ProStudio


Prepare the excel

In order to import product information you must first prepare the document with the correct data. There will be some mandatory fields, they are defined under the section: 

  • “Settings/Advanced/Product attributes”


Please see Configure product attributes in the help section.


These mandatory attributes could be product number or EAN (GTIN) or something that makes each item in the list unique.


Download one product to get a template

If you are uncertain what the format looks like you can always download oneproduckt together a template. Please go to the product listing view and filter one product, then press export. This will give you an excel file with all the required headings.


Start importing

When you start importing you must have access to the importing function. Once you can access the importing function you will should follow these steps

  1. Select a file to import.
  2. Map columns in your excel with the system
    1. If you use a template from the system you may just click “Includes header row”
    2. This will give you a button that says "Auto calculate column mapping by header"
  3. Then press import
  4. This will validate the list of values you want to import

 

NOTE: One of the columns will be your unique identifier and this column CANNOT have duplicate values. If you have to rows with the same identifier, only the first one will be imported.


After import

When you have imported your products you will get a message stating what products was imported If some of the products already existed in ProStudio, they will be updated with new information and you will be informed about how many new products were created and how many that was updated.


What can't be imported

Currently you may only import text information. This means that you can’t import tags.

Tags needs to be updated on the items after import.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article