How to import & export items in CSV files Loyverse POS


[Music] exporting and importing items each type of items ordinary items composite items items with variants the multi-store items of specific points you have to pay attention to when importing ordinary items items that are not composite and does not have variants create sample items in the item list carefully fill in all the fields with pallets and switch on the option that you need [Music] export items are the csv file open csv files but there’s ways to open it from google sheets [Music] you will see the sheet with your sample items follow the pattern of your sample when filling fields of edit items [Music] if the field truck stop has a value of N or is blank in stock and low stock fields must be blank if you want to specify the item price during a sale leave field equal price empty [Music] sku is an obligatory field and should be unique for each item [Music] two items without variants leave the handle field blank [Music] save the spreadsheets in the CSV format at the back office click on the import button in the import menu choose your CSV file from your computer and click upload you will see information on how many items and categories will be created or edited click confirm import click OK and continue work you will see all your imported items in the list multiple stores you have several stores in the list open item list and create sample items [Music] carefully fill in all the fields with values and switch on the option that you need export items as a CSV file open your CSV file the best way is to open it from Google sheets [Music] in case of you have multiple stores you will have the following columns for each store follow the pattern of your sample icons when filling in the fields [Music] you can set the values of these parameters for each of your stores if you want to specify the item price during a sale leave this field empty sku is an obligatory field and should be unique for each item two items without variants it is better to leave the handle field blank in the importing file save the spreadsheet in the CSV format import all items to the list [Music] you’ll see all your imported items in the list [Music] items with variants [Music] create sample items in the item list carefully fill in all the fields with values and switch on the option that you need [Music] fill in the option name on the left field and the variance for this option on the right field press Enter button on your keyboard after each variant name finalize the entry [Music] export items are the csv file open csv file the best ways to open it from google sheets there are three columns each for option name and option value if some products have less than three options of variants the extra fields are left blank follow the pattern of your sample items when filling in the fields [Music] only the fields of the first item with variants have values the fields that are common to all variants of the same item are left blank you may also fill them with the same value but if they have a different value you will get an error message when importing the handle field is required items with variants it should be the same for all variants of the same item why times without variants it is better to leave the handle field blank save the spreadsheet in the CSV format import all items to the list [Music] you’ll see all your imported items in the list composite items [Music] create sample items in the item list carefully fill in all the fields with values and switch on the option that you need [Music] export items as a CSV file open csv file the best way is to open it from google sheets [Music] each composite item includes several components follow the pattern of your sample items when filling in the fields specify SKU codes of all the included items of the selected composite item in the field SKU of included item on a separate roll quantity of included item in this field it’s necessary to specify the quantity of the component that is included in one unit of the composite item [Music] you cannot track stock of composite items so leave the pills that are related to stop slang save the spreadsheet in the CSV format import all items to the list [Music] you

Leave a Reply

Your email address will not be published. Required fields are marked *