Lightspeed (R-Series) Historic GC import

Table of Contents

• Overview

  • File Cabinet

  • CSV

    • Supported Columns

    • Formatting

  • Upload & Processing

Overview

For Go live with Lightspeed, any Gift Cards in Lightspeed should be exported with Code needed to import to NetSuite for Redeeming and the Balance Amount needed for Redeeming.
The Following is what is required to be setup to successfully Import the Gift Card to NetSuite with their own Cash Sales to have the Gift Cards in NetSuite available to Be redeemed for New transactions from Lightspeed.

File Cabinet

In the NetSuite File Cabinet, create a “LS Gift Card Import” Folder. Within that Folder also Create a “LS Gift Card Import Results” Folder:

The CSV, after formatting, will be Uploaded to the “LS Gift Card Import Folder”

CSV

Supported Columns

• Customer

  • Value should be Internal ID

• Quantity

  • Should be 1

• Item

  • Value should be Internal ID of the Gift Certificate Item

• Gift Card Code

• Amount

  • Amount of the Gift Card Code to be created

• Location

  • Header Location

• Location Line

  • Line Location if Applicable

• Subsidiary

  • If set should be same as Customer’s Subsidiary

• Memo

  • Receommend “LS Historic GC import”

• Department

  • Value should be Internal ID

• Discount Item

  • Value should be Internal ID

• Discount Rate

  • Should be -100% to not record Revenue

Other Mandatory Field should be ignored by the Script Creation process

Formatting

Example of Formatting Completed:

Upload & Processing

Upload the Complete File in CSV to the File Cabinet folder “LS Gift Card Import”, and get the FILE internal ID

Go to Customization > Scripting > Scripts > Filter Type to Map Reduce > Find the Script “In8 Lightspeed Gift Card Import MR”

Then Go to Deployments SubTab and click on the Deployment

Edit the Deployment
Then Set the CSV File Internal ID in the Field “File Cabinet File Internal ID”
Then Set the “LS Gift Card Import Results“ Folder Internal ID in the Field “LS GC Import Results Folder”

Then if Ready, Save and Execute the Deployment to Process the CSV to create the Cash Sales, and at the End of Processing there will be a Results File in the Results Folder for Review

Execution Log on the Script Deployment can be monitored as well,

When Downloading the Results CSV, when opened, the Code Column will probably need to be formatted to Correct the way Excel handles codes in CSV

Any issues with the process please reach out to In8Sync through Support cases on ​https://in8sync.com