Skip to main content

Bulk Price Updates with API (For Advanced Users)

How to programmatically update blk prices using Reusely’s public API for seamless integrations with your workflow tools.

Written by Althaaf Rachman Hafidz

Purpose

The API option is designed for advanced users who want to automate pricing updates. Use this method to connect Reusely with platforms like Zapier for real-time, scalable price management.


Before You Start

Make sure to use the sheet format from Reusely, by Settings → Price Editor → Upload Price button → Download CSV or XLSX template.


Video Walkthrough

Watch our tutorial to see how bulk pricing updates with API helped with Zapier.


Steps

1. Prepare Your Files

  • Access Edit Product Pricing

  • Click Price Upload and download your template (CSV or XLSX)

    Select Price Upload Tab
    Download CSV Template

  • Edit or update the price (without changing any forms) and upload it to your Google Sheet.

    Open Uploaded File

Optional

You may also merge the template into an existing Google Sheet, as long as the column format remains identical.

2. (Alternative) Use a Zapier Account

Use Zapier to sync pricing changes from Google Sheets directly into Reusely.

Google Sheet Trigger Setup

Setup:

  1. Log in to Zapier and click Create → Zaps

    Select Zaps Tab

  2. Select Google Sheets as the Trigger App

    Start New Zap Creation
    Select Google Sheets App

  3. Choose New or Updated Spreadsheet Row (Instant)

    Select New or Updated Row Trigger

  4. Login to your Google Account

    Confirm Trigger Settings

  5. Click Continue

    Continue Zap Setup

Configure:

  1. Select your Spreadsheet File

    Select Live Pricing Update

  2. Choose the Worksheet

    Select Specific Row

  3. Define a Trigger Column (recommended: condition-based)

    Create New Zap Step

  4. Click Continue

    Continue Zap Configuration

Tip

Do not change column names or structure, this ensures reliable automation.

Test:

  1. Click Test Trigger

    Execute Trigger Test

  2. Confirm Zapier detects spreadsheet data

    View Test Records

  3. Click Continue with Selected Record

    Confirm Test Record

Webhook Trigger Setup (Reusely API)

Setup:

  • Set the Action Event to Custom Request

    Open Zapier Home Menu

  • Click Continue

    Select Custom Request

Configure:

  1. Set Method to POST.

    Confirm POST Selection

  2. Enter the URL using your Reusely Public API Secret Key: https://docs.reusely.com/v2.0/reference/post_api-v2-admin-pricing.

    Review HTTP Request Details

    Note:

    You can found under Price Upload > Alternates > step number 7.

  3. Set Data Pass-Through to False.

    Open Data Field

a. Body Configuration:

  1. Fill in the Data field using code generated from:

    1. Reusely Public API Version 2

  2. Under Body Params:

    1. Set Name: (Item's condition)

      Enter Condition Name

    2. Set Price: Temporary value (auto-updated later)

      Enter Price Value

  3. Repeat for each condition

    Open Conditions Array
    Select Condition Name Field

  4. Copy the final code from the right panel

    Open JSON Payload

  5. Paste it into the Data field.

    Edit Conditions JSON

  6. Click + to to map spreadsheet value to condition names

    Add Field Mapping
    Select New Condition Mapping

  7. Set Unflatten to No.

    Select Basic Auth

  8. Leave Basic Auth empty.

    Select Basic Auth

b. Headers:

  1. Set the Header as follows:

    Add Secret Key and Content-Type
    • x-secret-key: (Your Reusely Public API Secret Key)

    • Content-Type: application/json

  2. Set Return Raw Response to No.

    Open Raw Data Input

  3. Click Continue.

    Continue to Next Step

Test & Publish

  1. Review Data In and Data Out to verify Zapier reads correctly.

    Publish Zap

  2. Click Publish to activate your Zap.

    Publish Zap

After Update:

  • Update any prices in your Google Sheet.

  • Click Refresh under Zap Runs,

  • or Replay from the navigation menu.

  • Your changes will automatically sync with your Price Editor in Reusely.


Tips & Notes

  • API integration is recommended for advanced users familiar with workflow automation tools.

  • As Zapier handles a lot of customer requests, Reusely does not offer direct integration with Zapier, but through the Public API.

  • Always test changes in a controlled environment before applying large pricing updates.


Using the Reusely Public API with Zapier streamlines bulk pricing updates, making price management faster and more scalable. It’s ideal for setting initial prices or updating pricing in bulk across both standard and custom catalog items.

Did this answer your question?