Forum Discussion

MikeBlane's avatar
MikeBlane
Member
3 years ago

Why do some imported items, update prices and some dont?

Hi, I am trying to import items with new pricing, but not all items have prices updated after the import. Some price break levels are left at $0.00. The error log says "X records were imported witho...
Mike_James's avatar
Mike_James
Ultimate Cover User
3 years ago

Hi AndrewStephen , thanks, I've just been reading a thread of yours and exchanges with the Doc. 

 

I note that a value of zero is basically ignored in the import/export wizard, so that rules that method out. 

 

Did your developer make these changes via the API? If so, then provided there is no corruption in the price breaks (the 4077 error) then resetting via the API should be a valid method for any developer.

AndrewStephen's avatar
AndrewStephen
Valued Cover User
3 years ago

Hi Mike_James 

 

Yes, all our price changes are down via the API and no issues seen.

We have now been down price changes via the developed app for just over 12 months.

At this stage we are only doing the prices. I recently asked him to make the changes to allow the app to update any of the item details.

 

What we do is

  1. Get the ItemPriceMatrix for the item
  2. Compare if Qty Breaks have changed do a reset on the QTY Break if they have.
    (This is basically sending a 0 for the 1st Qty Break)
    We then Get the ItemPriceMatrix again for the item and compare the prices
    If the prices have changed update those prices
  3. Repeat for All items in our pricelist update.

We do this daily for items in our pricelist.

Other than the API timeout, gateway etc errors I haven't seen any error related to the update of the prices / qty breaks.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.