Scheduled exports refresh your Google Sheets sheets with orders, shipments, and costs, and bulk imports read orders and rate cards back out.
| Type | Format | Rows | Status |
|---|---|---|---|
| Invoice Audit | xlsx | 1,284 | Pending |
| Finance Invoices | xlsx | 312 | Pending |
| Invoice Audit | xlsx | 5,902 | Pending |
Spreadsheet tool for exporting shipping data and custom reporting.
Authorize Google Sheets and choose the workbook and sheets CommerceShip refreshes and reads. Access is scoped to those files and can be revoked from either side.
Match export fields to the columns your pivots use, and save a column mapping for the order, rate card, and address imports you read back out.
Each run appends to the sheet or replaces the range, and imports read from the mapped sheet on demand.
Exports refresh the sheet on a schedule. Orders, rate cards, and address lists import from the sheet with a saved column mapping.
Warehouses, databases, spreadsheets, and file storage you can send the same shipping data to
