ImportItemSelling Price

Question

Hi Everyone&nbsp;I tried to import the selling price for 2000+ item codes. It does tell me the item codes were updated without errors but when I look at the items, the items still do not have the selling price.&nbsp;&nbsp;

mike_james · Answer

Hi&nbsp;tfaccounts&nbsp;, I suggest you break up the import file and import files of 500 lines or less. I tried with 1000 rows&nbsp; last month, and had the same result. I tested up to 500, which worked. Larger files might work but I haven't tested them.&nbsp;&nbsp;If you are importing prices for quanitty break 1, then you need to inlcude that field, with a 0 in it.

tfaccounts · Answer

Hi&nbsp;Mike_James&nbsp;&nbsp;I tried to reduce to 494 lines and it still did not work.Does MYOB need to run a script?&nbsp;&nbsp;

mike_james · Answer

Hi&nbsp;tfaccounts&nbsp;, that would normally only be necessary if there was a particular error message. I think you said there were no errors.&nbsp;&nbsp;Can you post a small sample of the lines from your import file?

genreve_s · Answer

Hi tfaccounts,&nbsp;
&nbsp;
Thanks for posting.&nbsp;
&nbsp;
I understand that importing information to the file is the best way to update item codes.&nbsp;
&nbsp;
Generally, if the import process does not affect the prices but has no error importing, we need to check the import file to see what causes it not to read the information. As Mike_James has suggested, you can send a line of the import file here for us to check.&nbsp;
&nbsp;
Also, I would suggest making an export file to compare it with your import file.&nbsp;
&nbsp;
We look forward to your response.&nbsp;
&nbsp;
Cheers,&nbsp;Genreve&nbsp;
&nbsp;

gavin12345 · Answer

Hi&nbsp;tfaccounts&nbsp;&nbsp;I suggest you&nbsp;get MYOB to run as duplicate price matrix script (not error 4077 which might be script&nbsp;Mike_James&nbsp; is referring to).&nbsp;When you have duplicate price matrix entries, MYOB has 2 entries for the same item/price level and quantity. So it might well update one of them, however it will display the other one. I have seen this lots of time when prices do not seem to update, yet no error is reported.&nbsp;RegardsGavin

Forum Discussion

Import>Item>Selling Price

Looking for something else?

Related content

Prices printing incorrectly

Item Price change

INVENTORY PRICE LEVEL

4066 Errors for price import

EXO/ Supplier price break

update Selling price

Standard cost price

MYOB Pricing change to Subscriptions