error code 37 when uploading csv files via file exchange

[peeknservices]

Gretings,

I am having issues changing prices using file exchange,

I download my file CSV & open in Excel (also tried open office ods), change the pricing in the speadsheet.

I change the item number from "scientific ?" format back to a number (no decimal places) so that it looks like an item number.

I save the file again as a csv file & upload.

I am continually get the following message

"Error - Input data for tag <Item.ItemID> is invalid or missing. Please check API documentation.|Item.ItemID|"

I have a mixture of single line items (each with it's own ItemID) & some listings with variants which all fall under the one ItemID.

The Error codes Reference does not cover this.

Any advice / guidance would be appreciated.

[gec2002 · Accepted solution]

Are you just changing price, if so did you use

"File Exchange - Revise Price and Quantity".

If not try using that (change ItemID to non-scientific).

If you used a different download can you upload a photo of the download result

[peeknservices · Accepted solution]

Thank you for your reply, it is apreciated I don't know that I have this option -- "Revise price & Qty". Please see attached _FX001 Perhaps I am looking in the wrong place? Cheerz

[peeknservices · Accepted solution]

Thanks very much, I think I have it sorted now, cheerz