Costco 2-Pack Converter

Enter the Costco 2-pack SKU and the order quantity. The tool works out how much of the regular product you need to convert — 2-pack units × 2 = regular units, then regular units ÷ units per case = cases to pull.

Paste Cx email

Paste the Cx team email text here — every 2-pack SKU and its quantity is pulled out automatically. Expected format: 13781 – NS Dry Eye – 17 CAS (102 x 2pks); 15526 – NV 500ml – 14 CAS (42 x 2pks). The quantity is the number right before “x 2pks”. Then type each regular product's own Batch # and Expiry right in the table below (expiry as MM/DD/YYYY, like SAP shows) — they flow to that SKU's labels and to its lines in Step 2 and Step 3. Each row also has its own Labels / box setting, with that SKU's total labels (cases × labels per box) shown beside it. The Carton# and Version in the Order section apply to every SKU, and labels for all of them are generated together.

Order

Costco 2-pack SKU The SKU on the Costco order (e.g. 13613)

Quantity Number of 2-packs on the order

Product name Optional — printed on the 2-pack case labels

UPC (for the label barcode) UPC of the 2-pack — fills in automatically for known SKUs

Carton# Printed on the labels — 001, same as the original labels; the same Carton# goes on every label in this run

Version Printed on the labels under the Carton# — same value on every label

This 2-pack SKU isn't in the list yet. Enter the regular product it converts from, and the conversion will run with those numbers.

Regular product SKU Your inventory SKU that gets converted

Units per case Pack size of the regular product (e.g. 12)

Step 1 — Create Batch

In SAP, create each batch from its Costco 2-pack SKU, Batch # and Expiry — tap Copy beside a value to copy it exactly, with no extra spaces. Only SKUs with a batch # entered are listed here. Once a batch is created in SAP, tap its ✓ Created button — that row disappears, so the same product and lot can't be copied or created twice. When every row is done, the full list comes back, ready for the next order.

Step 2 — Create: Costco 2-Pack

Step 3 — Remove: Our Product (NWC)

Regular SKU to pull

—

Regular units needed

—

Cases to pull

—

Batch # — regular product

Expiry — MM/DD/YYYY

Costco 2-pack labels

Labels per box

Zebra printer — ZPL

Same labels as ZPL code for the Zebra label printer at 203 dpi: the landscape BarTender design rotated 90° onto the 4×6 in stock — exactly like the printer's “90° – Landscape” setting — filling the whole label with no border. Copy it, paste it into labels.txt, and run your usual print-labels.bat — same as the TJX labels.

SAP workflow — follow the steps in order

Create batch (if needed)

Enter each regular product's batch # and expiry (MM/DD/YYYY) from its LS24 FIFO lookup — in its row of the email results table, or in the result area for a single SKU. Every SKU with a batch entered is then listed in the Step 1 — Create Batch section above Step 2, with a copy button for its 2-pack SKU, batch # and expiry.

Create the Costco 2-pack

MB1A — movement type 952, reason for movement 558 (Step 2 section above).

Remove the regular product

MB1A — movement type 951, reason for movement 558 (Step 3 section above).

Known 2-pack SKUs

Costco 2-pack SKU	Product	Regular SKU	Units / case	UPC

Every regular product is 12 units per case, except 11453 (2-pack 15526), the only 6-pack, at 6 units per case. Any 2-pack SKU not listed here can still be converted with the manual entry above.