How to collect Dropbox photo and PDF links in bulk

One page for all four marketplaces. The orange numbers on the screen match the steps below.

1. 1Sign in — there's a login box at the top. Any account role — reviewer, editor, or admin — gets full use of this tool, no difference between them. No account yet — ask an admin to make one on the Accounts page.
2. 2Pick the marketplace: Overstock, Amazon, or Boscov.
3. 3Pick the search method: Search by Supplier SKU (default) or Search by internal model number. Amazon has no toggle and only searches by UPC (Section 3).
4. 4Paste one value per line in the big box, as many as you like. Overstock needs the values grouped by family (Section 2).
5. 5Click Search & save. A long list is processed in batches: the status line shows "X / total" and the seconds waited, and the results table appears when it's done (Section 4).
6. 6The saved links are in Saved links at the bottom of the page, where you can copy or download them (Section 5).

Only Overstock has families. On every other marketplace one value per line is enough.

1. 1The top three lines share the style number (194S9516) and the set marker (-1PWH) and differ only in color, so they are one family automatically. 194S1031BGY-1 has a different style number, so it is another family.

How the automatic grouping works: same style number, same set marker, only the color code differs. The set marker is the -1, -2, #2, #3 in the SKU, including any PW-style tail. So:

The tool saves one row per member of a family:

Line drawings are the files named _7, _71, _72; the tool uses all the line drawings of the first member that has any (a master can have 2–3). Variation Image never holds the room scene or line drawings. A single dining chair without color variants (item type "Dining Room Chairs") has no Variation Image at all. A single piece named by component (for example a bar set with _TBL_1, _CHR_41) has those shots in its gallery, table first. A # master named by component (a dining set #5) leaves them out and takes only the last component's line drawing (the chairs' _CHR_7).

Amazon only looks for the assembly PDF, not photos, and only searches by UPC.

1. 1Set the marketplace to Amazon.
2. 2The search-method toggle disappears and a plain "Search by UPC" label takes its place. It's the only method.
3. 3Paste one UPC per line, like 194840303640. The tool looks in Dropbox /Ying/Amazon/Amazon_AI for a file named exactly InstallationManual_194840303640.pdf and saves its link in the Assembly Instructions field.

One row per input.

1. 1The Images count is how many links this row saved. For Amazon it's 1 if the PDF was found and 0 if not.
2. 2The Status column says created when the SKU hadn't been saved before, or updated when it had and the new links replaced the old ones. Re-running a SKU never makes a duplicate row.
3. 3The Error column says why a row failed. Other rows carry on. The usual one is "could not find a Supplier SKU": a typo in the model number, or no Dropbox folder for that product yet.
4. 4A grey small text is a hint, not an error. The usual one is "master gallery built by file name": that master's photos all sit in one folder with no subfolder of its own, so the tool assembled the gallery by file name. Give it a quick look.
5. 5An error saying rate-limited or HTTP 5xx means Dropbox is throttling or the request timed out (the limit is shared company-wide, so someone else running it at the same time counts too). The page retries on its own first; if it still fails, wait a few minutes and paste the failed rows again. Rows that succeeded don't need rerunning, and rerunning never makes duplicate rows.

Every search saves its links at the bottom of the same page, one marketplace at a time, ready to copy into the upload template.

1. 1By default it shows every row of the latest run, in the order you pasted. Switch to All to browse history, most recent run first.
2. 2The search box filters by Supplier SKU or model number; part of it is enough.
3. 3Copy links copies only the links, in that marketplace's upload-template column order, one SKU per row with blanks where there is no link, ready to paste into Excel. Copy with SKU puts Supplier SKU and model number in front. Download CSV adds a header row. The screen only shows columns that have a link; copy and CSV always use the full template columns.
4. 4The first row (anchor) of a multi-color family carries Product PDF 1, PDF 1 Type, and the Product Image columns.
5. 5Each other color in the family gets its own row and only fills Variation Image.

1. 1raw=1 links point at the file itself, which the Overstock and Boscov upload templates need. dl=1 links start a download when opened, which only Amazon uses. The tool adds the suffix, so don't edit it by hand.
2. 2For Amazon, Internal Model Number only has a value when our database knows that UPC; otherwise it stays blank and the link is unaffected.
3. 3There is one row per marketplace + Supplier SKU, and SKUs that differ only in letter case count as the same one. Re-running a SKU overwrites its row; it never adds another.