Lightspeed Onsite - Bulk Product Update

Bulk product updates may be processed using Lightspeed's Import Tools.  To update web products in bulk you can export products from Lightspeed and then using Lightspeed Onsite’s Import Tools to check or re-check “Web” for multiple products at once. 

 

 

The computer used to initiate this bulk update will be in use by Lightspeed until the update completes. We recommend performing Bulk Updates after hours so that this has the least impact on your business.

 

 

 

First, you will want to export your Web products from Lightspeed. This can be done in the main product window by selecting, then exporting, all web enabled products.

1. Go to Products in Storemaster.
   
   
2. Add "Web" and "ID" to your View Columns.
   
   
   
   
3. Search all Product IDs for "P-", press Enter, then press "New".
   
   
   
   
4. Change the Smart Find criteria to match the below image:
   
   
   
   All of the following are true:
   
   • Product ID contains P-
   • Web is checked.
   • Current is checked.
     
     
5. Export the file from the Action Menu at the bottom of the screen:
   
   

 

 

Update Products
Next, update products using the export you just created so that the products are marked as modified by Lightspeed and sent via the Lightspeed API to Accumula.

 

Important: Be careful and take your time when performing bulk uploads.

1. Backup your Lightspeed Database by navigating to Tools > Utilities > Backup Database.
   
   
   
   
2. Go to Tools > Imports Tools > Products and Open File.
   
   
   
   
3. Set the options to:
   • Update Products
   • Matching on: Product ID.
4. IMPORTANT: Depending on the version of Lightspeed Onsite:
   • Click the action menu to Deselect All. 
   • Click the checkbox to the right of "Omit This Record" to Deselect All.
5. Drag the fields on the right to match them to the associated fields on the left.
   • Product ID
   • Web