Export formatting

boviobovio Member Posts: 29

Can somebody please explain to me if I'm missing something very obvious or if this is just LS missing the mark? I manage two stores, both on LightSpeed. If I have a new item I created in one inventory, one would think I could easily export the item and then import it to the other store using the item importer feature. However, the issue I've run into is that I'll export a number of items and then run it through the importer only for it to have no idea what to do with it. The export has headings like "Item" and "Manufact. SKU", where the importer requires it be "Description" and "Manufacturer SKU", respectively. And the export will have values like "428.000000000" for a $428.00 item, and of course the importer just throws errors at me when I try to import ("Default Cost value is not supported"). I know that I HAVE to be the problem here, because a POS certainly wouldn't overlook something this obvious. Any help?

2 comments

  • RiderRider Member Posts: 3

    I have the same problem.

    Why isn't the item export formatted the same as the input format requirements?

    Especially for items that are part of a Matrix.

    I expected it to format with the correct column headers, and the matrix description / attributes if applicable, but it exports them as individual items and the column headers don't even conform to import requirements as per above

  • GJN757GJN757 Member Posts: 5

    I brought this issue up with Lightspeed in 2018. It makes absolutely no sense. Lightspeed also removed certain column headers from the inventory export such as the reorder point and reorder level. The only suggestion I received from Lightspeed was to export both the inventory listing and a similar file under quick edit items then perform a Vlookup function to merge those headers. Sadly I do not see this issue being addressed anytime soon.

Sign In or Register to comment.