Skip to main content

Upload Linelist by Excel Import

Before adding any SKUs into the system, make sure the following items have been created for your collection: see Season Linelist Preparation

  • Season/Linelist Code
  • Sizescale
  • Pricelist
  1. Download the SKU generator template at the end of this article
  2. Open the downloaded Excel file and select Enable Macros

                  

  1. Go to the Template Fill in the product detail in appropriate columns. Column headers in red indicate it is a mandatory field to build the SKU.
    The SKU naming convention is style-colorcode-size. Do not use characters such as +, *, ^, ?, “, (, )

 Tip: Are all products you are loading in the same Season/Linelist? If your spreadsheet consists of products in multiple season/linelist, include in one of the Additional columns.
For other additional information, in Blast Ramp, select Click here to view for more upload options. Any fields you like to use, enter into one of the Additional columns just like Season/Linelist 

  1. Delete any columns that are not used (right click on the column header, select Delete)
    Example of a completed template:

 

  1. Once you are satisfied with your template data, go to the View tab at the top or Tools > Macros > Macros
  2. Highlight “Create SKUs” then select Run.

Note: For step 5 and 6,  depending on your version, the steps may be slightly different.

  1. You are now in a new worksheet called “Output”. This is the page you need to copy your data and paste into the portal

Highlight all your data, copy by Mac - Command+C) or Windows - CTRL+C.

Tip: For the ease of mapping the columns, Insert a new row in the first row. Type in 1, 2, 3, 4 … across each column but do not copy this row.

         

  1. In Blast Ramp, go to Advanced > Utilities > Upload Linelist via Copy and Paste from Excel.
  2. Paste the copied data, from step 8 above, directly into the blank space provided in section 1- data box.
  3. The purpose of section 2 – Standard data positioning is letting the system know what each column means.

Default Value is used if all the products have the same value.  

        

SKU – under column A therefore, enter “1” (or refer to the number on the first row of the column)

Product Description - under column B therefore, enter “2”

Unit Type – please use Default Value’s dropdown to choose your value

*to add values to the drop down, go to Advanced > Administration > Under Portal settings, select Unit Type*

Catalog Sequence – If you use catalogs as a selling guide sorted by non alphabetical method, please contact Support for further tools to help improve efficiency.

Color Description ­– under column C therefore, enter “3”

Season/Linelist Code – If Season/Linelist is not indicated in the blue part of your template, you must enter a Default Value here. Check that the code entered here matches the list in Portal Settings.

Other additional columns – select Click here to view more upload options and enter its respective column number. Refer to step 3.

  1. Section 3 – Customer related positioning will have your created Pricelist listed. The procedure is the similar to section 2 – data positioning in step 11.
  2. Section 4 – Select warehouse(s) will show all related warehouse(s). Use the checkbox to identify which warehouse you wish to load the SKUs into. You may select multiple warehouses.
  3. Commit this data to the warehouses? - uncheck to preview before committing the import. Checked tells the system to commit the import It will still display the import.
    Exact SKU?     Not needed for what we are trying to accomplish here. This is used for updating any fields within this screen.
    Hide Post Results?     If previewing the data load took over a minute, we recommend checking this function. This is usually the case for loading more than 500 SKUs. This should only be used after you get comfortable with bulk uploading SKUs.
  4. If error occurs,
    1. Double check the character limit (includes space) outlined in the first worksheet of the Excel file
      Season/Linelist = 16 characters
      Color description = 50 characters
      Description = 200 characters
      SKU = 50 characters (consist of style-colour code-size)
    2. Check for any invalid characters such as +, *, ^, ?, “, (, )
    3. Check sizescale, pricelist, season/linelist and unit type exists in your Portal (Advanced > Admin > under Portal Settings)

When successfully loaded, just below the Post Results, you will see this message:

                     

Tip: to verify your import, go to Inventory > Mass Edit > Select Season

 

Was this article helpful?
Powered by Zendesk