Skip to main content
Solved

Import for updating PriceBook prices


Chris_Perkins
Hero (Customer)
Forum|alt.badge.img+12

Hi, 

Using V15.4.2 currently and we had the wrong prices imported into  a PriceBook ready for 2024 and they now need to be changed.  The import sheet in Alliance will not allow me to overwrite those prices with the corrected ones, it runs through but afterwards I find the prices are not changed.

If I try to delete those prices, i only have the option to delete the products, which also removes ALL pricing.

Does anyone know a way to either:

  • Delete pricing from a PriceBook for a list of products but ONLY for those with a specified FROM DATE?
  • Or how to replace current prices with revised ones?

I need this for Products and Activities please.

Thank you

Best answer by Phil Seifert

Hi Chris (and Sean),

I believe this API might work for you:

<root xmlns:dt="urn:schemas-microsoft-com:datatypes">
  <session email="" alias="">
    <state bc_name="product">
      <action name="data">
        <product>
          <row number="1">
            <bpart_id dtype="string" in_var="" out_var="">018080000</bpart_id>
          </row>
        </product> 
        <bpartprice>
          <row number="1">           
            <price>400</price>
            <bo_search_keys>              
              <item>
                <name>pbookh_id</name>
                <value>00000017</value>
              </item>
              <item>
                <name>pbookl_fr_date</name>
                <value>12/1/2023</value>
              </item>              
            </bo_search_keys>
          </row>
        </bpartprice>
      </action>
    </state>
  </session>
</root>

Note, the second search key for the pbookl_fr_date is only necessary if you need to update a single specific row when there are multiple prices for the product on different dates.  If you only have a single row or don't care that all the row prices are updated, you can remove this search key.

Hope this works for you but if needing further API development assistance, this should be requested as a Services billable task.

 

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 20 replies
  • December 5, 2023

Hello Chris - I am just responding as I have been monitoring this post and have the same Pricing import problem running 15.4.5. Have you had any response to this or determined any other solution? 

 

Thanks, Sean


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+24
  • Ultimate Hero (Employee)
  • 1322 replies
  • Answer
  • December 6, 2023

Hi Chris (and Sean),

I believe this API might work for you:

<root xmlns:dt="urn:schemas-microsoft-com:datatypes">
  <session email="" alias="">
    <state bc_name="product">
      <action name="data">
        <product>
          <row number="1">
            <bpart_id dtype="string" in_var="" out_var="">018080000</bpart_id>
          </row>
        </product> 
        <bpartprice>
          <row number="1">           
            <price>400</price>
            <bo_search_keys>              
              <item>
                <name>pbookh_id</name>
                <value>00000017</value>
              </item>
              <item>
                <name>pbookl_fr_date</name>
                <value>12/1/2023</value>
              </item>              
            </bo_search_keys>
          </row>
        </bpartprice>
      </action>
    </state>
  </session>
</root>

Note, the second search key for the pbookl_fr_date is only necessary if you need to update a single specific row when there are multiple prices for the product on different dates.  If you only have a single row or don't care that all the row prices are updated, you can remove this search key.

Hope this works for you but if needing further API development assistance, this should be requested as a Services billable task.

 


Chris_Perkins
Hero (Customer)
Forum|alt.badge.img+12
  • Author
  • Hero (Customer)
  • 151 replies
  • December 6, 2023

Hi Phil,

Thank you, we’ll give it a go.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings