This article is a quick reference guide to collecting information with the Solid Commerce Excel Tool's Retrieve Data button.
What we'll cover in this article:
- Two Ways to Retrieve Information
- Retrieving Information About Specific Products
- Retrieving Entire Warehouses or Market Lists
- Related Articles
Two Ways to Retrieve Information
The Solid Commerce Excel Tool lets you Retrieve two ways, depending on whether you have a set of SKUs (or Warehouse IDs) lined up to search for.
- If you have SKUs or IDs (plus what Warehouse or Market List they're in), you'll Retrieve that set of products.
- If you don't have them, or just want to be thorough, you can Retrieve everything in a set of warehouses or market lists.
(There's also a third tool that's similar to Retrieving: enter a search in the web UI, and click Export Products or Export Listings to download the search.)
All of these (including Export) give you Excel information that's already formatted so you can Upload it right back, as soon as you've made any changes you want — perfect for fast work.
Retrieving Information About Specific Products
1) In Row 1, put the column headers for the information you want to Retrieve. (You don't need any other columns yet.)
- You might get these from Excel's Solid Commerce menu -> Manage Excel Columns, or by copying and pasting from another Excel tab.
- Or you could keep files on hand that have the sets of headers you usually Retrieve and Upload with.
2) Add the columns, and fill in the data for:
- results (can be empty)
- product custom sku
- warehouse id
- Either the SKU or ID column can be empty below the header. But if you have multiple IDs per SKU, you don't want to leave ID empty.
- either warehouse name or list name (or both)
TIP: if you have other rows of information that you don't want to Retrieve to yet, you can still keep them on the tab; just put them under the "Retrieving rows" and add a blank row between them. The Retrieve will stop at that blank row.
3) Click the Retrieve Data button, and enter your Solid Commerce authentication in the popup.
- In the second popup, click Retrieve information on items existing in this sheet (Rows will not be added to Excel)
- Click the Continue button.
4) Don't do any work in Excel until it stops flashing and displays a small, brief Completed window.
Then you'll see your completed Retrieve, with information on every product up until it reached a blank row.
Retrieving Entire Warehouses or Market Lists
1) In Row 1, put the column headers for the information you want to Retrieve. (You don't need any other columns yet.)
- You might get these from Excel's Solid Commerce menu -> Manage Excel Columns, or by copy and pasting from one Excel tab to a new empty tab, or keeping a tab with these headers ready for Retrieving.
2) Add the column headers (with no data below them):
- results
- product custom sku
- either list name (to retrieve from Market Lists) or warehouse name (for warehouses or vendor lists)
3) If there's anything below Row 1, delete it. (Or copy and paste the headers to a blank tab.)
4) Click the Retrieve Data button, and enter your usual Solid Commerce authentication in the popup.
5) In the second popup, click Retrieve all products from a specific list.
- Click the Continue button.
- In the new popup, find and check the checkboxes for one or more Market Lists, Warehouses, or Vendor Inventory Lists you want to retrieve from.
- Click the Get Products button.
6) Give Excel a few seconds or more; don't do other work in it until you see the brief Completed window.
Your completed Retrieve will have all the products in those lists or warehouses.
TIP: if you check any Market List boxes, you'll get cleaner results if you don't check any Warehouses or Vendors on the same Retrieve. You can get most of their fields from Market Lists anyway
Comments
Article is closed for comments.