Skip to content
English
Support Portal
Ramp
  • There are no suggestions because the search field is empty.

Importing a Stocktake to Shopify

This guide covers how to import a stocktake from the Ramp Web Portal to Shopify.

Overview

After completing a stocktake using the RFID handheld, stock levels can be:

  • Automatically updated via Current Stock Sync, or

  • Manually reviewed and imported into Shopify

This guide explains the manual process.

It is recommended to perform stocktake review and import outside of peak trading hours to minimise discrepancies caused by ongoing sales.

To learn how to start and scan a stocktake, refer to Performing a Stocktake.

23/01/2026: Please note that the Shopify import configuration has been updated and Ramp is currently working on a solution to import stock counts. Please contact support@ramp.com.au if you wish to update stock counts.

Phase 1: Exporting the Variance Report

1. Log in to the Ramp Web Portal. 

2.  Navigate to Items -> Inventory List.

3. Select View on the relevant stocktake.

4.  Select Reports -> Variance - External.

5. Select Export -> For Shopify to download the CSV file.


Phase 2: Reviewing the Variance

The exported file contains two sections:

Variance Analysis (Columns A-F)

These columns are for review and verification only.

Column Field Description
A SkuName SKU display name
B SkuNumber Unique SKU identifier
C SkuBarcode Barcode identifier
D Ramp Count Scanned stock count
E Shopify Count Current Shopify stock
F Variance Difference between Ramp and Shopify

Only the Ramp Count column may be adjusted if corrections are required.

Shopify Upload (Columns G-L)

These columns are formatted for Shopify inventory import.

Column Field Purpose
G Handle Shopify product identifier
H Option1 Value Variant option 1
I Option2 Value Variant option 2
J Option3 Value Variant option 3
K Location Store location
L Available Final stock value to upload

Verification

Before proceeding:

  • Review large discrepancies between Ramp count and Shopify count.
  • Confirm zero-quantity stock results
  • Perform another cycle count if required
  • Investigate potential missed reads or misplaced items

Phase 3: Preparing the Shopify Upload File

Columns G-L are formatted for the Shopify inventory import. Only the Available column is used by Shopify to update inventory.

If you adjusted Ramp Count during review, ensure the correct value appears in Available.

Creating the Upload File

1. Open a new Excel or CSV file.

2. Copy columns G-L into the new file

3. Save the file as a CSV file.

 

Select Upload File to complete the process

Phase 4: Importing into Shopify

  1. In Shopify, navigate to Products > Inventory

  2. Select Import

  3. Select Add File.

  4. Upload the prepared CSV file.

  5. Select Upload File to complete the process.

Operational Considerations

  • Manual import overwrites existing Shopify inventory values.

  • Sales occurring between stocktake and import may affect accuracy.

  • Always verify the file before uploading.

  • Retain a backup of the original export for audit purposes.