⚙️ Introduction

This job allows the creation and update of Offers (stocks and prices) via CSV import or API Connector.

You can:

• Create and update Offer Stocks
• Create and update Offer Prices
• Deactivate or delete stocks and prices
• Define pricing rules including price ranges and offer types

---

📂 Import model

CSV Structure

The CSV file must contain one row per Offer Stock / Offer Price combination.

📄

Template CSV

You can use the following spreadsheet as a template to structure your import:

Offers - Template

---

API Connector

When using the API Connector, DJUST does not receive a JSON payload directly. Instead, the job executes a 3-step file generation flow:

1. Call 1 — File generation (POST /offer/file/generate): triggers the generation of a CSV file on the external system. A sinceUpdateDateTime parameter can be passed to retrieve only records updated since the last job execution.
2. Call 2 — Status polling (GET /offer/file/status): polls the external system until the file is ready. The job retries until the statusFile attribute returns AVAILABLE.
3. Call 3 — File download (GET $.urlFile): retrieves the URL returned by Call 2 and downloads the CSV file for processing.

💡

Note

The API Connector processes the same CSV format as the SFTP import. The difference lies only in how the file is retrieved — via API calls rather than from an FTP server.

---

📋 Fields

☑️

Conditionally required

⚠️

Required Custom Fields

Any custom fields configured as required in DJUST must also be included.

---

🧠 Key Business Rules

• An Offer is composed of two linked objects: an Offer Stock (identified by Stock External Id) and an Offer Price (identified by Price External Id). An Offer Price must always be linked to an existing Offer Stock.
• Price Ranges must always include a range for quantity 1. Graduated pricing (volume discounts) can be defined by adding additional ranges.
• Offer Type determines the pricing audience: PUBLIC applies to all buyers; ACCOUNT restricts the price to a specific customer account (Customer Account External Id required); GROUP restricts the price to a customer tag (Customer Tag required).
• Setting Delete Stock to TRUE removes the Offer Stock and all associated Offer Prices.
• Setting Delete Price to TRUE removes only the targeted Offer Price, without affecting the stock.
• Setting Active Stock to FALSE deactivates the stock and makes it invisible to buyers without deleting it.
• Empty fields in standard columns do not delete recorded values.
• Empty fields in Custom Fields delete the recorded values.

Price Ranges Format

The priceRanges column uses a pipe-separated (|) format to define pricing tiers and (||) to separate ranges Required: creation + update

Standard price:

quantity|unitPrice||quantity|unitPrice

Example: 1|100 → 1 unit, price 100

With discount price:

quantity|unitPrice|discountPrice||quantity|unitPrice|discountPrice

Empty Field Behavior

The OFFER import uses a conditional update approach: only fields that are explicitly provided are modified.

Offer Stock

Offer Price

---

📌

Best Practices

✔️ Always include a Price Range for quantity 1 to avoid import errors.

✔️ Ensure Customer Account External Id or Customer Tag is provided when using ACCOUNT or GROUP offer types.