Import/export

  • Resolved gatechnz

    (@gatechnz)


    3 years, 3 months ago

    Hi there.
    Nice plugin by the way.
    I’m trying to figure out on how to assign a supplier for the products using the export/import features from your plugin.
    So far, I have tried with no luck:
    – Inventory – Download to Excel (Downloaded the spreadsheet, added the fields on “supplier” column, saved it.)
    On import: (Settings – utilities – import) I get this error:” Row 2: There is no value for product – this is required (No data was imported)”

    – Settings – utilities – export – (Data type: Inventory) (Downloaded the spreadsheet, added the fields on “mainSupplier” and/or “mainSupplier.id” column, saved it.)
    On import: (Settings – utilities – import) I get this error: ” Row 2: Cannot load value into calculated field avgUnitCostExclTax – old value: 0; new value: NaN (No data was imported)”

    Any help would be greatly appreciated.

    Thanks.

Viewing 1 replies (of 1 total)
  • Plugin Author pau1andrews

    (@pau1andrews)

    Hi Gus,

    I would load up the product suppliers first before you worry about costs – for this you only need the ProductSupplier datatype. (Just export, set the supplier names, then import).

    Once you’ve done that, then export Inventory, and delete all columns except for the id, and avgUnitCost. Then make sure all of the avgUnitCosts are set correctly and import.

    Kind Regards,
    Paul Andrews

Viewing 1 replies (of 1 total)
  • The topic ‘Import/export’ is closed to new replies.