Live

Route a whole batch from one CSV or XLSX sheet

One CSV or XLSX sheet controls copy and routing for a batch. Rows match artwork by filename or filename stem.

Availability
Live
Last verified

What this does

One CSV or XLSX sheet controls copy and routing for a batch. Rows match artwork by filename or filename stem.

Before you begin

  • Use these exact columns: filename, title, description, seo_title, seo_description, alt_text, product_tags, store, and line.
  • Use per-image JSON instead when artwork will wait in a paced batch or a per-store timed release.

What changes outside ArtDrop

The worker scans admitted CSV and XLSX files in the incoming queue. It matches filename or stem case-insensitively. Per-image JSON wins conflicts and a sheet fills blank JSON fields.

Steps

  1. Use the exact schema

    The tag column is product_tags, not tags. Store and line are singular. A sheet does not provide the plural stores fan-out list.

  2. Match filename or stem

    A row for IMG_5072.jpg, IMG_5072, or a case variation can match the same artwork.

  3. Keep the sheet with immediate work

    Upload the sheet with artwork that will process now. For a paced batch or delayed per-store copy, move the necessary values into each image's JSON sidecar.

  4. Inspect the destination

    Copy Log contains Live Log lines, not the sheet values. Inspect the exact external record to confirm the applied copy and route.

Expected result

An immediately processed artwork uses its matching nonblank sheet values, unless its JSON supplies a more specific value. Delayed artwork uses its carried JSON instead.

Good to know

  • CSV and XLSX sheets are each limited to 2 MiB. The parser defines no row-count or per-cell character cap.
  • The exact tag key is product_tags. A tags column is ignored.
  • Unknown store or line names fail only when a real multi-store or product-line setup exists. In an effectively single-store setup, the worker warns and uses default routing.
  • CSV and XLSX copy sheets are accepted.
  • CSV and XLSX copy sheets are accepted.
  • Each CSV or XLSX copy sheet is limited to 2 MiB. ArtDrop does not currently set a row-count or per-cell character limit.

Troubleshooting

  • Delayed item ignored sheet values? That hold path did not carry the sheet. Put the values in matching JSON before admission.
  • Tags missing? Rename the column product_tags and verify the filename or stem match.

How to undo or clean up

Correct the sheet before a new immediate drop. Existing provider products and listings must be edited in the service that owns them.