Skip to main content
POST
/
api-price
/
price
/
bulk-insert
Add or Update Bulk Price
curl --request POST \
  --url https://prod01-apigw.{customer_name}.fabric.zone/api-price/price/bulk-insert \
  --header 'Content-Type: application/json' \
  --header 'x-api-key: <x-api-key>' \
  --header 'x-site-context: <x-site-context>' \
  --data '
[
  {
    "priceListId": 100000,
    "itemId": 1000011218,
    "offers": [
      {
        "channel": 12,
        "startDate": "2021-12-30T02:05:47.234Z",
        "endDate": "2099-12-31T00:00:00.000Z",
        "price": {
          "base": 2000,
          "currency": "USD",
          "sale": "",
          "cost": ""
        },
        "kind": 0,
        "range": [
          {
            "minQuantity": 2,
            "price": 500
          }
        ]
      }
    ],
    "itemSku": "1234XYZ"
  }
]
'
import requests

url = "https://prod01-apigw.{customer_name}.fabric.zone/api-price/price/bulk-insert"

payload = [
    {
        "priceListId": 100000,
        "itemId": 1000011218,
        "offers": [
            {
                "channel": 12,
                "startDate": "2021-12-30T02:05:47.234Z",
                "endDate": "2099-12-31T00:00:00.000Z",
                "price": {
                    "base": 2000,
                    "currency": "USD",
                    "sale": "",
                    "cost": ""
                },
                "kind": 0,
                "range": [
                    {
                        "minQuantity": 2,
                        "price": 500
                    }
                ]
            }
        ],
        "itemSku": "1234XYZ"
    }
]
headers = {
    "x-site-context": "<x-site-context>",
    "x-api-key": "<x-api-key>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)
const options = {
  method: 'POST',
  headers: {
    'x-site-context': '<x-site-context>',
    'x-api-key': '<x-api-key>',
    'Content-Type': 'application/json'
  },
  body: JSON.stringify([
    {
      priceListId: 100000,
      itemId: 1000011218,
      offers: [
        {
          channel: 12,
          startDate: '2021-12-30T02:05:47.234Z',
          endDate: '2099-12-31T00:00:00.000Z',
          price: {base: 2000, currency: 'USD', sale: '', cost: ''},
          kind: 0,
          range: [{minQuantity: 2, price: 500}]
        }
      ],
      itemSku: '1234XYZ'
    }
  ])
};

fetch('https://prod01-apigw.{customer_name}.fabric.zone/api-price/price/bulk-insert', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));
<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://prod01-apigw.{customer_name}.fabric.zone/api-price/price/bulk-insert",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    [
        'priceListId' => 100000,
        'itemId' => 1000011218,
        'offers' => [
                [
                                'channel' => 12,
                                'startDate' => '2021-12-30T02:05:47.234Z',
                                'endDate' => '2099-12-31T00:00:00.000Z',
                                'price' => [
                                                                'base' => 2000,
                                                                'currency' => 'USD',
                                                                'sale' => '',
                                                                'cost' => ''
                                ],
                                'kind' => 0,
                                'range' => [
                                                                [
                                                                                                                                'minQuantity' => 2,
                                                                                                                                'price' => 500
                                                                ]
                                ]
                ]
        ],
        'itemSku' => '1234XYZ'
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Content-Type: application/json",
    "x-api-key: <x-api-key>",
    "x-site-context: <x-site-context>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}
package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://prod01-apigw.{customer_name}.fabric.zone/api-price/price/bulk-insert"

	payload := strings.NewReader("[\n  {\n    \"priceListId\": 100000,\n    \"itemId\": 1000011218,\n    \"offers\": [\n      {\n        \"channel\": 12,\n        \"startDate\": \"2021-12-30T02:05:47.234Z\",\n        \"endDate\": \"2099-12-31T00:00:00.000Z\",\n        \"price\": {\n          \"base\": 2000,\n          \"currency\": \"USD\",\n          \"sale\": \"\",\n          \"cost\": \"\"\n        },\n        \"kind\": 0,\n        \"range\": [\n          {\n            \"minQuantity\": 2,\n            \"price\": 500\n          }\n        ]\n      }\n    ],\n    \"itemSku\": \"1234XYZ\"\n  }\n]")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("x-site-context", "<x-site-context>")
	req.Header.Add("x-api-key", "<x-api-key>")
	req.Header.Add("Content-Type", "application/json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}
HttpResponse<String> response = Unirest.post("https://prod01-apigw.{customer_name}.fabric.zone/api-price/price/bulk-insert")
  .header("x-site-context", "<x-site-context>")
  .header("x-api-key", "<x-api-key>")
  .header("Content-Type", "application/json")
  .body("[\n  {\n    \"priceListId\": 100000,\n    \"itemId\": 1000011218,\n    \"offers\": [\n      {\n        \"channel\": 12,\n        \"startDate\": \"2021-12-30T02:05:47.234Z\",\n        \"endDate\": \"2099-12-31T00:00:00.000Z\",\n        \"price\": {\n          \"base\": 2000,\n          \"currency\": \"USD\",\n          \"sale\": \"\",\n          \"cost\": \"\"\n        },\n        \"kind\": 0,\n        \"range\": [\n          {\n            \"minQuantity\": 2,\n            \"price\": 500\n          }\n        ]\n      }\n    ],\n    \"itemSku\": \"1234XYZ\"\n  }\n]")
  .asString();
require 'uri'
require 'net/http'

url = URI("https://prod01-apigw.{customer_name}.fabric.zone/api-price/price/bulk-insert")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["x-site-context"] = '<x-site-context>'
request["x-api-key"] = '<x-api-key>'
request["Content-Type"] = 'application/json'
request.body = "[\n  {\n    \"priceListId\": 100000,\n    \"itemId\": 1000011218,\n    \"offers\": [\n      {\n        \"channel\": 12,\n        \"startDate\": \"2021-12-30T02:05:47.234Z\",\n        \"endDate\": \"2099-12-31T00:00:00.000Z\",\n        \"price\": {\n          \"base\": 2000,\n          \"currency\": \"USD\",\n          \"sale\": \"\",\n          \"cost\": \"\"\n        },\n        \"kind\": 0,\n        \"range\": [\n          {\n            \"minQuantity\": 2,\n            \"price\": 500\n          }\n        ]\n      }\n    ],\n    \"itemSku\": \"1234XYZ\"\n  }\n]"

response = http.request(request)
puts response.read_body
[
  {
    "_id": "616e011037a3810008cfb256",
    "priceListId": 100000,
    "isSoftDeleted": false,
    "itemId": 1000011218,
    "itemSku": "1234XYZ",
    "offerId": 381933,
    "offers": [
      {
        "kind": 0,
        "channel": 12,
        "startDate": "2021-12-30T02:05:00.000Z",
        "endDate": "2099-12-31T00:00:00.000Z",
        "price": {
          "base": 2000,
          "sale": null,
          "cost": "",
          "currency": "USD"
        },
        "offerCode": 123786,
        "range": [
          {
            "_id": "616e143828d0b800086dd84a",
            "minQuantity": 2,
            "price": 500
          }
        ]
      }
    ],
    "createdAt": "2021-10-18T23:19:44.852Z",
    "updatedAt": "2021-10-19T00:40:30.341Z",
    "job": false
  }
]
{
  "code": 400,
  "message": "SKU cannot be empty"
}
{
  "code": 500,
  "message": "An internal error occurred. If the issue persists please contact support@fabric.inc."
}

Headers

​
x-site-context
string
required

The x-site-context header is a JSON object that contains information about the source you wish to pull from. The mandatory account is the 24 character identifier found in Copilot. The channel (Sales channel ID), stage (environment name), and date attributes can be used to further narrow the scope of your data source.

Example:

"{\"date\": \"2023-01-01T00:00:00.000Z\", \"channel\": 12, \"account\": \"1234abcd5678efgh9ijklmno\",\"stage\":\"production\"}"

​
x-api-key
string
required

The x-api-key enables you to access the fabric API without Authorization. You must request fabric Inc to obtain this key.
Authorizationheader is required ifx-api-key` is omitted.

Body

application/json

Array of Items

​
priceListId
required

Pricelist Id or name. this is optional. Price will be updated for Default Pricelist if priceListId is not provided.

Example:

100000

​
itemId
number
required

Item ID

Example:

1000011218

​
offers
object[]
required

Offers

Required array length: 1 - 10 elements
​
itemSku
string

SKU

Example:

"1234XYZ"

Response

Successful

​
_id
string

ID

Example:

"616e011037a3810008cfb256"

​
priceListId
number

Price List ID

Example:

100000

​
isSoftDeleted
boolean

Has been soft deleted

Example:

false

​
itemId
number

Internal Item ID

Example:

1000011218

​
itemSku
string

Produtct SKU

Example:

"1234XYZ"

​
offerId
number

Offer ID

Example:

381933

​
offers
object[]

Offers

Required array length: 1 - 10 elements
​
createdAt
string<date-time>

Date and time of creation

Example:

"2021-10-18T23:19:44.852Z"

​
updatedAt
string<date-time>

Date and time of updated

Example:

"2021-10-19T00:40:30.341Z"

​
job
boolean

Job

Example:

false