5/30/2023 0 Comments Lightspeed onsite price![]() ![]() Using the window’s two-column layout, match the target fields in the second column with your source data in the first column by dragging and dropping them into the proper order. To omit a record, use the Browse slider to find the record and click Omit This Record. It is recommended that you include the column headings in your file, as they can be omitted when you do the import but are useful for matching fields. ![]() This file must be a tab-delimited text file or a comma-separated text file, and each line should represent a different record. On the Tools menu click Import Tools > Import Products.Ĭlick Open File and find the source file that contains your original data.Qty and Corresponding Sell Price of Quantity DiscountsĬustomer ID you can import for use with Contacts (undisplayed)Ĭustomer ID for matching purposes only (not importable)Ĭustomer First Name/Last Name in same fieldĬustomer default language for printed documents Quantity for reorder amount or reorder to max Use 0 to indicate reorder amount and 1 to indicate reorder to max. ![]() Primary, secondary & tertiary Web store categories margin setting for modified selling priceĭimensions of product box, used for web shipping Product ID used for matching purposes only The Product Code as it appears in Lightspeed OnSite * Make sure that the values you're importing match these OnSite values. Your data needs to match these names, so modify the data you're importing to match these names.Some fields use other pre-defined value lists that are already part of OnSite, such as Phone Type, which has values such as Work or Fax. The original data can use 1 or 0 rather than Yes or No. Yes values enable the attribute and No values do not. In some cases, where the target field is a checkbox attribute within Lightspeed OnSite (such as serialized), the original data must be Yes or No, or you can click the detail arrow to select a value - yes or no - to be imported into each record. Phone Types, Inventoried, Serialized, Editable Sell, among others The data you import can be one of three types:Ĭlass, Family, Tax Status, Supplier, Currency, Web Categories, POS Categories, User, Color, Size, GL Accountsįor example, if you have speakers in your source data and you want to import it into Lightspeed OnSite’s Class target field, the word speakers must already be in Lightspeed OnSite’s list of Classes.įor example, if you have Tucson in your original data, it will be added to your Customer/Supplier record, but will not modify your list of pre-defined values in Lightspeed OnSite. Open the file in Microsoft Excel or iWork Numbers to see the data presented in a format that you can use as a guideline for arranging your data. Download and unzip the product import template.In OnSite StoreMaster, manually back up your data. ![]() Once you've validated the import process, you can re-enable your eCom integration to sync your inventory. This allows you to validate that your products were imported properly, and if necessary, restore your inventory from a backup, before OnSite syncs your new products with eCom. NOTE: If you're an Omnichannel customer (OnSite with eCom), we strongly recommend that you turn off your eCom integration prior to importing new products into OnSite. You can also update existing products by matching on a field and importing new data into the fields that you specify.īefore you import products make sure you've configured your store, because certain product attributes need to be defined before you can perform an import. When you import new products, OnSite creates a new product card for each line item you import. Each line item in the source data represents one record in your OnSite product database. You can import products from a text file that your supplier provides you, which can save time creating and maintaining products. You can import data for products, customers, suppliers, and contacts. If you're migrating from a different system to Lightspeed OnSite, or if you want to add a supplier’s price list to your database, importing is a simple way to batch import or update data to OnSite. ![]()
0 Comments
Leave a Reply. |