Generate New Item Import Files For Lightspeed
LM

Lance Muzslay

Created Jul 03, 2022

Generate New Item Import Files For Lightspeed

Click the "Next" button below to see the process.

610
    a

Getopt

7 Steps
1

Create a matrix if it doesn't yet exist

  • In order to use this tool a matrix has to exist and you will end up attaching the new items to an existing matrix.

  • If you don't already have a matrix in which to attach the new items, create an empty matrix in Lightspeed.

  • Make sure you select the correct Matrix Type / Attributes.

  • You do not need to fill in any attributes such as colors, sizes, colors since that will be done during the import process.

Create a matrix if it doesn't yet exist
2

Click on Tools

Click on  Tools
3

Fill out the form for the existing matrix, style number, color code(s) and any width(s) you want to *exclude*.

It's usually easier and less error prone to enter the matrix ID number instead of the description. You can find the matrix ID number by looking for the id=# in the browser address bar when viewing the matrix in Lightspeed. For example:

https://us.merchantos.com/?name=item_group.views.item_group&form_name=view&id=123&tab=setup

For styles with a large amount of colors (ie, Brooks Ghost) you may not want to create all the colors in the matrix because that creates a lot of clutter with items that you'll never carry. It's a good practice to specify only the colors which you reasonably think you'll carry or take special orders for.

Fill out the form for the existing matrix, style number, color code(s) and any width(s) you want to *exclude*.
4

Review the data and if it looks good, click the "Download the .csv file" button and save the file to your computer.

Review the data and if it looks good, click the "Download the .csv file" button and save the file to your computer.
5

Click on "Go to Lightspeed Import" to open the Lightspeed import function.

Click on "Go to Lightspeed Import" to open the Lightspeed import function.
6

Click on the "New Import" button

Click on the "New Import" button
7

Choose the file you just saved in your computer.

It's usually best to select "Crew new items only" if there are already some existing items in the matrix.

Choose the file you just saved in your computer.
    u

Merchantos

1 Step
8

Select "Create new items only".

Select "Create new items only".
    a

Getopt

2 Steps
9

Click on Review import

Click on Review import
10

The Review Import screen should confirm that new items are about to be created. Click the "Import items" button to execute.

The Review Import screen should confirm that new items are about to be created. Click the "Import items" button to execute.
Well done!
Create how-to guides like this in a snap. Get Tango now.