Jump to content

Trying to import CSV with supply order details, get error.


Recommended Posts

Here's my problem:

 

Try to import CSV to add product to supply order details

 

 

This is the CSV(formatted for readability):

id_supply_order;

reference;

id_product;

supplier_reference;

quantity_expected;

quantity_received;

price_te


2;

TES001;

65;

null;

10;

11;

0.000000
 
These are the fields I assigned in the "view your data" window
 
Supply Order Reference * -> id_supply_order(2)
reference -> IGNORED(TES001)
Product ID * -> id_product(65)
supplier_reference -> IGNORE(null)
Quanity Expected * -> quantity_expected(10)
quantity_received -> IGNORED(11)
Unit Price (tax excl.) * -> price_te(0.000000)
 

 

This is the error: Product (65/0) is not available for this order (at line 1).

 

I don't understand the error, and I don't know why I'm getting it, why is it?

 

I don't see how this can update stock on combinations, as it's basing itself on the product ID, not the reference.

 

Thanks

Edited by amando96 (see edit history)
Link to comment
Share on other sites

  • 3 months later...

Amando96, were you able to solve this issue?

 

I am having the exact same problem, seems to work fine whenever i import a product without combinations, but no matter what I try I get the same error as above for any products with combos.

 

Any advice would be much appreciated! 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...