Back to workspace
中文

CSV intake

Imports

Make CSV and spreadsheet import reliable first, then connect Shopify, Amazon, Etsy, eBay, and TikTok Shop APIs.

Open import workbenchView SKU library

CSV templates

Download a template, fill SKU, channel, price, and cost fields, then upload it in the batch workbench.

Generic

Generic SKU CSV template

Source type: Manual sheet

Use this template to move spreadsheet SKUs into the batch workbench with automatic field mapping.

Mapped fields

sku, channel, salePrice, productCost, fulfillmentCost, shippingCost, adCost, returnReserve, targetMarginRate

Notes

  • Works for sourcing quotes, manual assortment sheets, and lightweight SKU lists.
  • Keep one SKU per row before uploading.
gj-sku-template.csv

Amazon FBA

Amazon settlement template

Source type: Settlement / FBA estimate

Normalize Amazon settlement, FBA fee, and ad-cost assumptions into SKU-level profit fields.

Mapped fields

sku, channel, salePrice, productCost, fulfillmentCost, shippingCost, adCost, returnReserve, targetMarginRate

Notes

  • The channel column accepts Amazon FBA, Amazon, or FBA.
  • Allocate ads by order or SKU before import.
gj-amazon-settlement-template.csv

Shopify

Shopify order export template

Source type: Order export

Normalize Shopify order exports into SKU profit fields before the Admin API integration lands.

Mapped fields

sku, channel, salePrice, productCost, fulfillmentCost, shippingCost, adCost, returnReserve, targetMarginRate

Notes

  • Use after combining Shopify orders, payment fees, and fulfillment costs.
  • Customer acquisition cost can be entered as adCost.
gj-shopify-order-template.csv

Etsy

Etsy settlement template

Source type: Marketplace settlement

Normalize Etsy transaction fees, payment processing, handmade/POD cost, and shipping into SKU profit fields.

Mapped fields

sku, channel, salePrice, productCost, fulfillmentCost, shippingCost, adCost, returnReserve, targetMarginRate

Notes

  • Listing and payment fees are estimated by fee rules; keep product-side costs in the import.
  • POD cost can go into productCost or fulfillmentCost.
gj-etsy-settlement-template.csv

eBay

eBay settlement template

Source type: Marketplace settlement

Normalize final value fees, shipping, clearance pricing, and ads into eBay SKU profit fields.

Mapped fields

sku, channel, salePrice, productCost, fulfillmentCost, shippingCost, adCost, returnReserve, targetMarginRate

Notes

  • Useful for long-tail, clearance, and parts SKUs.
  • Keep shipping separate from marketplace fees to inspect break-even price.
gj-ebay-settlement-template.csv

TikTok Shop

TikTok Shop settlement template

Source type: Short-video commerce settlement

Normalize TikTok Shop commission, creator payout, ads, and fulfillment into SKU profit fields.

Mapped fields

sku, channel, salePrice, productCost, fulfillmentCost, shippingCost, adCost, returnReserve, targetMarginRate

Notes

  • Creator payout can start in adCost until a dedicated field exists.
  • Useful for fast-moving product tests and short-cycle reviews.
gj-tiktok-shop-settlement-template.csv