Divide imported price number by 100

  • Resolved coredesign

    (@coredesign)


    1 year, 6 months ago

    We are using a third-party api to sync products from an external database to our Woocommerce shop. The external database (for reasons known only to the external developer) exports product unit price in Canadian cents, while our shop is using the default Canadian dollars for currency.

    We are trying to figure out a way to divide the cents value by 100 to create a dollar value after the sync/import has occurred. Currently, products are showing prices of $8,500.00 when they should show $85.00. *For example*

    Is there a way for affect this division by 100 AFTER the data has been synced/imported?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Saif

    (@babylon1999)

    Hello @coredesign,

    I understand you want to edit the price of all products in bulk after importing them from an external database.

    You can check the Bulk Edit Products, Prices, and Attributes extension to bulk edit product prices.

    I should note that all extensions sold on WooCommerce.com have a 30-day refund policy. If the product doesn’t work the way you need it or you think another product would work better, we are more than happy to provide a full refund.

    Hope this helps!

    How are you syncing from the external source?

    Using a service like Zapier, N8N or Make you would be able to manipulate the price field to give you the correct format.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Divide imported price number by 100’ is closed to new replies.