General info

Why we need this

Right now our team manually downloads ZIPs of bag photos from an external partner. We use these images to review each bag’s shape, color, and condition, then send them to our retouch agency. That takes time. With this automation, as soon as someone checks “Import Photos” in Airtable, the system will:

1. Log in to the partner site and download the ZIP.

2. Extract all images.

3. Save them into Box under All Files/001_Sales/Bags/02 New Bags/External Partners_Luxclusif/YYYY_MM_DD/[SKU].

4. Attach the photos back into the Airtable record for our sales team to review right away.

This cuts out manual steps, speeds up review, and gives our photo team instant access for editing.

User story

As an Inventory Manager

I want to check a box and have all bag photos fetched, saved in Box, and shown in Airtable

So that I can import up to 30 bags at once without downloading or uploading by hand

Credentials

Direct Luxclusif Login

• Login URL: https://store.luxclusif.com/login?ReturnUrl=%2Fbags-2

• Email: sales@saclab.com

• Password: Dropship!

• API documentationLCI-LUXCLUSIF API DOCUME…

Luxclusif Stage API

Base URL: https://staging.upteamco.com/1api/

Credentials
ID:  2613
GET: 1135ae4224213c50304c1f46fc46468b
POST: 042756131e79896e2d1dfaa1b7b3ef99

Box

Account Type: Business

Limited Access App: Photo Import App
Client ID: x1e2jssnqvd0x48cpz3013nuzriy5sbh

Primary Access Token: gLkO6Q9yLSuCCdyJ6haFwyXRzUtF0xLr

	Acceptance Criteria	Screenshot
01	Start import Given up to 30 rows in “Bulk Bag Import” with valid “Photos (external)” links When I check “Import Photos” Then Status → “In Progress: Image Import” and the job kicks off Example “Photos (external)” link: http://store.luxclusif.com/product/DownloadImages?productId=275198
02	Download ZIP Given Status = “In Progress: Image Import” and correct login info Login URL: https://store.luxclusif.com/login?ReturnUrl=%2Fbags-2 Email: sales@saclab.com Password: Dropship! When the job hits each link Then it logs in, downloads the ZIP for each SKU, or on failure Status → “Error: Image Import”
03	Extract images Given a ZIP is downloaded When the system unzips it Then all JPG/PNG files are extracted
04	Upload to Box Given images are extracted When it makes folders All Files/001_Sales/Bags/02 New Bags/External Partners_Luxclusif/YYYY_MM_DD/[SKU] and uploads Then each image is in the right Box folder Link to box folder: https://app.box.com/folder/331484713369
05	Attach in Airtable Given Box upload succeeds for a SKU When it updates that record Then photos appear in “Product Images”, and Status → “Images Imported”
06	Batch size Given 30 rows checked and valid links When the job runs Then it finishes all within 10 minutes, with no failures for good links
07	Errors & retries Given any step fails for a SKU When an error happens Then it retries up to 3×, and on final failure Status → “Error: Image Import” but other SKUs continue