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 without errors"

Any comments or help would be appreciated.

Thanks.

13 Replies

Replies have been turned off for this discussion
  • AndrewStephen's avatar
    AndrewStephen
    Valued Cover User
    3 years ago

    Hi heirloom & Mike_James 

    You can't delete Qty Break via the standard import from with AccountRight or from applications like Transport (haven't tried again since the API was fixed for the ItemPriceMatrix issues).

    You will need to go through and delete manually the qty breaks for each time.
    It will be painfully slow to do manually.

    This is something we struggled with for a long time and we finally gave up in the end with Transport and the MYOB file import and had our developer write an application so we could import prices and change the reset / change the qty breaks as needed during the import.


    There is a pre-release of TransPost 4, I will test the new version this evenign and see if you can delete qty breaks for existing items.

    Regards

    Andrew

  • 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.