logo

Add Officeworks SKUs

GuideUpdated 2026-06-20

Officeworks products are identified by a SKU code (e.g. JBMS310BK) rather than an ASIN. Each SKU is paired with a store ID and a customer postcode so MCA fetches the price and availability for that specific store location.

Before you start

You need two things in place before adding SKUs:

  • An Officeworks collection — create one from the Collections page and set the supplier to officeworks.com.au. See Create a Collection.
  • A postcode registered under the officeworks.com.au domain. See Add a Postcode.

You will also need a valid store ID. Look one up with the public stores endpoint — no API key required:

List Officeworks Stores

POST
https://multicartapi.com/api/v1/settings/officeworks/stores/
No auth (public)

No request body is needed. The response lists every active store with its store_id, name, address, and state. Copy the store_id value (e.g. W411) — you will pass it with every SKU you add.

Response
{
"code": 200,
"data": [
  {
    "store_id": "W411",
    "store_name": "Officeworks Carindale",
    "address": "1151 Creek Rd, Carindale QLD 4152",
    "state": "QLD",
    "postcode": "4152",
    "phone": "07 3219 1600",
    "lat": -27.502345,
    "lon": 153.083210,
    "status": "active"
  }
],
"status": 1
}

In the dashboard

  1. Open Collections from the sidebar and select your Officeworks collection.
  2. Click Add SKUs and choose whether to add a single SKU or paste a comma-separated list.
  3. Enter the SKU code(s), pick the store, and confirm the postcode.
  4. Click Save. The SKUs appear in the collection's item list immediately.
Add Officeworks SKU modal showing fields for SKU code, store ID, and customer postcode
Enter the SKU, select your store, and confirm the postcode — then click Save.

Adding many SKUs at once?

Use the bulk CSV upload described below. Each row in the CSV can target a different store and postcode, which is not possible from the comma-separated modal.

Via the API

Add a single SKU

Create SKU

POST
https://multicartapi.com/api/v1/schedules/officeworks/sku/create/
API Key or Session Token
ParameterTypeRequiredDescription
collectionintegerRequiredCollection ID. The collection must have request_type officeworks.com.au.
skustringRequiredOfficeworks SKU code, e.g. JBMS310BK.
store_idstringRequiredOfficeworks store ID, e.g. W411. Must exist in the stores table — use POST /settings/officeworks/stores/ to look up valid IDs.
customer_postcodestring or integerRequired4-digit Australian postcode (e.g. 4500) or the integer ID of a Zipcode record. The server resolves either form against your registered postcodes.
curl https://multicartapi.com/api/v1/schedules/officeworks/sku/create/ \
-X POST \
-H "x-api-key: YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{
  "collection": 100,
  "sku": "JBMS310BK",
  "store_id": "W411",
  "customer_postcode": 4500
}'
Response
{
"code": 200,
"data": {
  "id": 77,
  "sku": "JBMS310BK",
  "store_id": "W411",
  "customer_postcode": "4500",
  "collection": 100
},
"status": 1
}

First SKU activates the collection

Adding the first SKU to an Officeworks collection automatically promotes it from draft to enabled. Duplicate SKUs within the same collection are rejected — uniqueness is per collection, not per store or postcode combination.

Add multiple SKUs at once

Use this endpoint to add a batch of SKUs in a single call. All SKUs in the request share the same store and postcode.

Create Multiple SKUs

POST
https://multicartapi.com/api/v1/schedules/officeworks/sku/create/multiple/
API Key or Session Token
ParameterTypeRequiredDescription
collectionintegerRequiredCollection ID.
skusstringRequiredComma-separated SKU codes, e.g. JBMS310BK,HPLAP001,DLLAT002.
store_idstringRequiredOfficeworks store ID applied to all SKUs in this request.
customer_postcodestringRequiredPostcode number or Zipcode row ID applied to all SKUs in this request.
curl https://multicartapi.com/api/v1/schedules/officeworks/sku/create/multiple/ \
-X POST \
-H "x-api-key: YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{
  "collection": 100,
  "skus": "JBMS310BK,HPLAP001,DLLAT002",
  "store_id": "W411",
  "customer_postcode": "4500"
}'
Response
{
"code": 200,
"data": {
  "success_count": 2,
  "error_rows": [
    { "sku": "DLLAT002", "error": "Duplicate SKU" }
  ]
},
"status": 1
}

Mixed stores or postcodes

All SKUs in a single /create/multiple/ call share the same store_id and customer_postcode. To target different stores or postcodes per SKU, make separate calls or use the bulk CSV endpoint below.

Bulk upload via CSV

Upload a CSV file when you want to add many SKUs, each potentially with a different store or postcode.

CSV format — include a header row with these exact column names:

sku,customer_postcode,store_id
JBMS310BK,4500,W411
HPLAP001,3000,W055
DLLAT002,2000,W120

Postcode must be registered

Each customer_postcode value in the CSV must match an existing postcode registered under your account for the officeworks.com.au domain. Rows with an unresolvable postcode or an invalid store_id are skipped and reported in error_rows.

Bulk Create SKUs (CSV)

POST
https://multicartapi.com/api/v1/schedules/officeworks/sku/create/bulk/
API Key or Session Token
ParameterTypeRequiredDescription
collection_idintegerRequiredCollection ID to add SKUs to.
csvfileRequiredCSV file with header row: sku, customer_postcode, store_id.
curl https://multicartapi.com/api/v1/schedules/officeworks/sku/create/bulk/ \
-X POST \
-H "x-api-key: YOUR_API_KEY" \
-F "collection_id=100" \
-F "csv=@/path/to/skus.csv"
Response
{
"code": 200,
"data": {
  "success_count": 48,
  "error_rows": [
    { "row": 12, "sku": "BADSKU99", "error": "Invalid store_id" }
  ]
},
"status": 1
}