Title: Import/export
Last modified: August 30, 2021

---

# Import/export

 *  Resolved [gatechnz](https://wordpress.org/support/users/gatechnz/)
 * (@gatechnz)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/import-export-50/)
 * 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](https://wordpress.org/support/users/pau1andrews/)
 * (@pau1andrews)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/import-export-50/#post-14825700)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/profitori_0c001a.svg)
 * [The E-Commerce ERP: Purchasing, Inventory, Fulfillment, Manufacturing, BOM, Accounting, Sales Analysis](https://wordpress.org/plugins/profitori/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/profitori/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/profitori/)
 * [Active Topics](https://wordpress.org/support/plugin/profitori/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/profitori/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/profitori/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [pau1andrews](https://wordpress.org/support/users/pau1andrews/)
 * Last activity: [4 years, 10 months ago](https://wordpress.org/support/topic/import-export-50/#post-14825700)
 * Status: resolved