Shopify is a leading eCommerce platform that allows businesses to create and manage online stores with ease. When integrated as a source in Flxpoint, Shopify enables seamless synchronization of product data, inventory levels, and order processing between your Shopify store and other sales channels or suppliers. This integration helps ensure that your Shopify store's information is always up-to-date, reducing the risk of overselling and improving order fulfillment efficiency.
How to connect
📋 Phase 1: Initial Source Setup
Access Fulfillment Sources
Log in to your Flxpoint account and navigate to the Fulfillment Sources section.
Create a New Source
Click Add Source to begin creating a new source for your Source connection.
Tip: Have your Source account credentials or API details ready to streamline setup.
Configure Source Details
In the Create Source popup:
Search for Source in the supplier directory and select it.
Enter the source name as "Source Supplier".
Select the type "Supplier" from the dropdown.
Click Save to proceed.
Start the Integration Process
After saving, you’ll see "You have not created any integrations yet." Click Get Started to set up the integration.
Note: You can use the same connection for multiple integration types without creating a new one each time.
🔐 Phase 2: Supplier Connection & Authentication
Select Authentication Method
In the Authenticate With Supplier popup, choose between:
OAuth2: Recommended for secure, automatic permission setup.
API Key: Use for manual setup if OAuth2 is unavailable.
Connect via OAuth2
For OAuth2:
Click Add Connection, then New Connection.
Select Source and choose OAuth2.
Enter your Store URL (e.g., https://your-store.sourceplatform.com). Find this in Source Admin under Settings > Domains.
Click Continue to be redirected to the Source login screen.
Log in, download the Flxpoint app, and Install it, approving requested permissions.
You’ll be redirected back to Flxpoint to complete the connection.
Important: Use the platform’s native URL (e.g., https://cool-store.sourceplatform.com), not a custom domain (e.g., coolstore.com).
Connect via API Key
For API Key, set up a custom app:
In Source Admin, go to Settings > Apps and Integrations > Develop Apps.
Click Create an App, name it "Flxpoint".
Click Configure Admin API Scopes and set permissions to:
"Customers" to "Read and write".
"Fulfillment services" to "Read access".
"Inventory" to "Read access".
"Locations" to "Read access".
"Orders" to "Read and write".
"Products" to "Read access".
Click Install App and copy the Admin API Access Token.
In Flxpoint, enter the Token and Store URL.
Click Continue to proceed.
Important: The access token is viewable only once. If you exit the page, delete the app in Source Admin and reinstall to generate a new token.
🔄 Phase 3: Configuration & Feature Setup
Set Up SKU Mapping
In the Master SKU section, map your Inventory SKU to Source’s Master SKU. Optionally, set a prefix (e.g., "SRC-") to identify Source inventory.
Pro Tip: A prefix like "SRC-" helps distinguish Source inventory in your Flxpoint dashboard.
Configure Additional Features
Set up integration features:
Get Inventory: Enable to import product data from Source. Set sync frequency (e.g., daily) and map fields (e.g., SKU, Stock Level).
Send Orders: Enable to send orders to Source for fulfillment. Map order details (e.g., Customer Name, Shipping Address).
Get Shipments: Enable to retrieve shipment updates from Source. Map fields like Tracking Number and Shipment Date.
Skip configurations by clicking Skip to adjust later in supplier settings.
Complete Setup
Review settings and click Save to finalize your Source integration. Manage inventory, orders, and shipments under Fulfillment Sources.
Next Steps: Run processes manually to verify sync accuracy before enabling automation.
×
![]()
Product Operations
The primary operation handles the bulk of your inventory management needs, while the secondary operation allows for more detailed control, such as focusing on specific products or updates
Get Inventory and Pricing & Quantity
Supported | Shopify - Get Inventory and Pricing & Quantity
Introduction to Shopify Get Inventory and Pricing & Quantity
Welcome to the Shopify Get Inventory and Pricing & Quantity integration guide! This integration retrieves inventory, pricing, and quantity data from Shopify into Flxpoint, syncing product lists, inventory levels, and variant details like cost and price. It ensures accurate inventory tracking across your Shopify store by integrating with Flxpoint’s Global Inventory Pool (GIP). Let’s get started!
The Shopify Get Inventory and Pricing & Quantity integration enables you to:
- Fetch product lists, inventory levels, pricing, and quantity data from Shopify for a specified location.
- Sync inventory quantities and pricing details with Flxpoint’s Global Inventory Pool (GIP) for centralized management.
- Support multi-location inventory by associating data with the correct Shopify Location ID.
The integration follows these steps:
- 1 Connecting to Shopify: Establish a connection using OAuth2 authentication to access your Shopify store.
-
2 Fetching Product List: A GET call to
/admin/api/{version}/products.jsonretrieves the product list for all locations. -
3 Extracting Inventory Item IDs: Creates a list of
inventory_item_idvalues from the fetched products. -
4 Retrieving Inventory Levels: A GET call to
/admin/api/{version}/inventory_levels.json?location_ids=xxxxxxfetches inventory levels for the specified location using the list ofinventory_item_id. - 5 Fetching Variant Details: Extracts pricing and quantity data (e.g., cost, price, quantity) from Shopify variants.
- 6 Mapping Data: Maps Shopify product and variant data to Flxpoint inventory fields using a mapping template.
- 7 Saving Data: Updates inventory quantities, pricing, and product details in Flxpoint’s Global Inventory Pool (GIP).
- 8 Execution: Run manually with Run Sync or schedule (e.g., daily).
Pro Tip: Schedule regular syncs to keep your inventory and pricing data up-to-date in Flxpoint.
Note: API failures pause the integration and trigger notifications.
Customize the integration with these settings:
- Connection: Select your Shopify OAuth connection (e.g., “Shopify Connection API - Shopify App (OAuth2)”).
- Location ID: Specify the Shopify inventory location ID to retrieve inventory levels (required).
- Mapping Template: Define how Shopify product and variant fields map to Flxpoint inventory fields (see Mapping Template Details).
- Sync Frequency: Run manually or schedule syncs (e.g., daily at 6 AM UTC).
Note: Verify the Location ID in Shopify to ensure inventory levels are fetched for the correct location.
Follow these steps:
- 1 Add the Integration: Go to Channels > Shopify > Integrations, select “Get Inventory and Pricing & Quantity.”
- 2 Connect to Shopify: Select an existing Shopify OAuth connection or set up a new one.
-
3 Configure Settings:
- Specify the Location ID for inventory retrieval.
- Configure sync frequency (e.g., daily at 6 AM UTC).
- 4 Create Mapping Template: Configure field mappings for products and variants (see Mapping Template Details).
- 5 Run the Integration: Start with Run Sync or schedule automatic syncs.
Mapping templates control how Shopify inventory, pricing, and quantity data is imported into Flxpoint.
Interface Overview
- Screen labeled “Get Inventory and Pricing & Quantity” at the top; name your template (e.g., “Shopify Inventory Sync 1”).
- Buttons: Delete, Duplicate, Save Mapping.
- Sections: Inventory Parent Fields (e.g., Title, Description), Inventory Variant Fields (e.g., SKU, Quantity, Price).
- Columns: Shopify fields (left, e.g., Shopify Product Title), Flxpoint fields (right, e.g., Title).
Mapping Options
- Don't Map: Ignore the field; no data is imported to Flxpoint.
- Set To Empty: Clear the field in Flxpoint.
- Direct Copy: Copy the field as-is (e.g., for All Images, All Custom Fields).
- Field: Map a Shopify field to a Flxpoint field (e.g., Shopify Product Title to Flxpoint Title).
- Value: Set a static value (e.g., Weight Unit to “lb”).
- Mapping Set: Apply a predefined mapping set for complex mappings.
- Rules: Apply conditional logic (e.g., map Category 1 only if Product Type matches a specific value).
SKU Mapping Requirement
The Shopify Variant SKU field must be mapped to ensure proper inventory identification in Flxpoint.
- Required Field: SKU uniquely identifies inventory variants.
-
Error Scenario: Unmapped SKU may cause inventory sync failures:
Invalid request: Missing required field 'SKU' for inventory sync
- Fix: Go to Channels > Shopify > Templates > Get Inventory and Pricing & Quantity > Field Mapping, map Shopify Variant SKU to Flxpoint SKU, save, and re-run sync.
Recommendation: Always map SKU, Quantity, and Title for reliable inventory syncing.
Complete Field Mappings
Below are the fields you can map from Shopify to Flxpoint, based on the provided mapping template:
Inventory Parent Fields
| Shopify Field | Maps To | Data Type | Example | Purpose | Status |
|---|---|---|---|---|---|
| Shopify Product - Title | Flxpoint Title | Text | Blue T-Shirt | Sets product title | Supported |
| Shopify Product - Body HTML | Flxpoint Description | Text | Comfortable cotton t-shirt | Sets product description | Supported |
| Shopify Product - Category | Flxpoint Category 1 | Text | gid://shopify/ProductTaxonomyNode/123 | Sets primary category | Supported |
| Shopify Product - Custom Collection 1 - Title | Flxpoint Category 1 | Text | gid://shopify/ProductTaxonomyNode/123 | Sets primary category | Supported |
| Shopify Product - Custom Collection 2 - Title | Flxpoint Category 2 | Text | gid://shopify/ProductTaxonomyNode/456 | Sets secondary category | Supported |
| Shopify Product - Custom Collection 3 - Title | Flxpoint Category 3 | Text | gid://shopify/ProductTaxonomyNode/789 | Sets tertiary category | Supported |
| Shopify Product - Smart Collection 1 - Title | Flxpoint Category 1 | Text | gid://shopify/ProductTaxonomyNode/123 | Sets primary category | Supported |
| Shopify Product - Smart Collection 2 - Title | Flxpoint Category 2 | Text | gid://shopify/ProductTaxonomyNode/456 | Sets secondary category | Supported |
| Shopify Product - Smart Collection 3 - Title | Flxpoint Category 3 | Text | gid://shopify/ProductTaxonomyNode/789 | Sets tertiary category | Supported |
| Shopify Product - Vendor | Flxpoint Brand | Text | BrandX | Sets product brand | Supported |
| Shopify Product - Tags | Flxpoint All Attributes | Text | summer, cotton | Sets product attributes | Direct Copy Supported |
| Shopify Product - Images | Flxpoint All Images | Text | image_url.jpg | Sets product images | Direct Copy Supported |
| Shopify Product - Handle | Flxpoint Parent SKU | Text | blue-t-shirt | Sets parent SKU identifier | Supported |
| Shopify Product - ID | Flxpoint Reference Identifier | Text | 123456789 | Sets reference identifier | Supported |
| Shopify Product - SEO Description | Flxpoint Custom Field | Text | SEO optimized description | Sets SEO description as custom field | Supported |
| Shopify Product - SEO Title | Flxpoint Custom Field | Text | SEO optimized title | Sets SEO title as custom field | Supported |
| Shopify Product - Product Type | Flxpoint Custom Field | Text | Shirt | Sets product type as custom field | Supported |
| Shopify Product - Template Suffix | Flxpoint Custom Field | Text | default-product | Sets template suffix as custom field | Supported |
| Shopify Product - Alternate Image Text | Flxpoint Custom Field | Text | Blue T-Shirt Image | Sets alternate image text as custom field | Supported |
Inventory Variant Fields
| Shopify Field | Maps To | Data Type | Example | Purpose | Status |
|---|---|---|---|---|---|
| Shopify Variant - SKU | Flxpoint SKU | Text | variant-sku-001 | Identifies the variant | Required |
| Shopify Variant - Title | Flxpoint Title | Text | Blue T-Shirt - Medium | Sets variant title | Supported |
| Shopify Variant - Quantity | Flxpoint Quantity | Number | 50 | Sets inventory quantity | Supported |
| Shopify Variant - Barcode | Flxpoint UPC | Text | 012345678905 | Sets universal product code | Supported |
| Shopify Variant - Barcode | Flxpoint GTIN | Text | 012345678905 | Sets global trade item number | Supported |
| Shopify Variant - Price | Flxpoint Source List Price | Number | $30 | Sets selling price | Supported |
| Shopify Variant - Compare At Price | Flxpoint MSRP | Number | $50 | Sets manufacturer’s suggested retail price | Supported |
| Shopify Variant - Compare At Price | Flxpoint MAP | Number | $45 | Sets minimum advertised price | Supported |
| Shopify Variant - Cost | Flxpoint Cost | Number | $20 | Sets product cost | Supported |
| Shopify Variant - Weight | Flxpoint Weight | Number | 0.5 | Sets variant weight | Supported |
| Shopify Variant - Weight Unit | Flxpoint Weight Unit (Abbreviated) | Key/Value | lb | Sets unit of weight | Supported |
| Shopify Variant - Grams | Flxpoint Weight | Number | 500 | Sets weight in grams (converts to Flxpoint units) | Supported |
| Shopify Variant - Options | Flxpoint All Options | Text | Medium, Blue | Sets variant options | Supported |
| Shopify Variant - SKU | Flxpoint Master SKU | Text | variant-sku-001 | Sets master SKU identifier | Supported |
| Shopify Variant - ID | Flxpoint Reference Identifier | Text | 987654321 | Sets reference identifier | Supported |
| Shopify Variant - Tax Code | Flxpoint Custom Field | Text | P000000 | Sets tax code as custom field | Supported |
| Shopify Variant - Alternate Image Text | Flxpoint Custom Field | Text | Blue T-Shirt Medium Image | Sets alternate image text as custom field | Supported |
| Shopify Variant - Inventory Item ID | Flxpoint Bin Location | Number | 456789123 | Sets bin location identifier | Supported |
| Shopify Variant - Position | Flxpoint Custom Field | Number | 1 | Sets variant position as custom field | Supported |
Additional Inventory Fields
| Shopify Field | Maps To | Data Type | Example | Purpose | Status |
|---|---|---|---|---|---|
| Shopify Variant - Barcode | Flxpoint ASIN | Text | B01N5IB20Q | Sets ASIN identifier | Direct Copy Supported |
| Shopify Variant - Custom Fields | Flxpoint All Custom Fields | Text | color: blue | Sets custom fields | Direct Copy Supported (Up to 100) |
| Shopify Variant - Custom Aggregate Fields | Flxpoint Custom Aggregate Fields | Key/Value | size: medium | Sets aggregate custom fields | Supported (Up to 10) |
| Shopify Product - Status | Flxpoint Archived | Key/Value | Active | Sets archived status | Supported |
| Shopify Variant - Inventory Policy | Flxpoint Allow Backorders | Key/Value | Continue | Sets backorder policy | Supported |
| Shopify Variant - Weight Unit | Flxpoint Dimension Unit | Key/Value | in | Sets dimension unit | Supported (in/cm) |
| Shopify Variant - Weight | Flxpoint Height | Number | 10 | Sets height (if applicable) | Supported |
| Shopify Variant - Weight | Flxpoint Length | Number | 20 | Sets length (if applicable) | Supported |
| Shopify Variant - Weight | Flxpoint Width | Number | 15 | Sets width (if applicable) | Supported |
| Shopify Variant - Cost | Flxpoint Dropship Fee | Number | $5 | Sets dropship fee | Supported |
| Shopify Variant - Price | Flxpoint Shipping Cost | Number | $10 | Sets shipping cost | Supported |
| Shopify Variant - Barcode | Flxpoint MPN | Text | MPN123 | Sets manufacturer part number | Supported |
GraphQL Integration Notice
Since 2025, our Shopify integration uses ShopifyGraphQL to enhance data processing. This change means the Category field must now use a valid global ID drawn from
Shopify's Taxonomy.
Note: Replace any plain text category values (for example, if you previously used "Consumer Electronics") with the correct global ID to prevent errors such as:
GraphQL Request Failed: ... Invalid global id ...
Practice Mapping
Try enabling/disabling Shopify Variant - SKU:
Flxpoint supports Shopify’s multi-location inventory for accurate inventory syncing:
- Location ID Requirement: Specify a Location ID in Flxpoint to fetch inventory levels for that location. Refer to Shopify’s guide on managing locations.
- Single Location Sync: The integration syncs inventory levels for one location per job, using the specified Location ID in the API call.
Pro Tip: Configure multiple integration jobs with different Location IDs to sync inventory across all Shopify locations.
Be aware of these constraints:
- Single Location Per Sync: Inventory levels are fetched for one location per sync job; multiple jobs are needed for multiple locations.
- SKU Requirement: Variants without SKUs may not sync properly and could result in incomplete inventory data.
- API Rate Limits: Shopify API rate limits may affect large inventory syncs; monitor usage to avoid interruptions.
Troubleshoot issues with these steps:
- Inventory Not Syncing: Verify the Location ID is correct and matches a valid Shopify location.
- Missing Quantities or Pricing: Ensure the Shopify Variant Quantity and Price fields are mapped to Flxpoint Quantity and Source List Price in the mapping template.
- API Errors: Check for Shopify API rate limit issues; reduce sync frequency if needed.
-
Incomplete Data: If variants are missing, ensure Shopify Variant SKU is populated and mapped:
Warning: Variant skipped due to missing SKU
Diagnostic Tip: Missing inventory often results from unmapped SKUs or incorrect Location IDs.
Key information:
- Date: As of 09:43 PM -04, May 29, 2025, this integration is operational.
- Required Fields: SKU and Quantity must be mapped.
- API Limits: Monitor Shopify API rate limits to avoid sync interruptions.
Pro Tip: Map SKU, Quantity, Price, and Title, and verify Location ID for reliable inventory syncing.
Conclusion
The Shopify Get Inventory and Pricing & Quantity integration streamlines inventory management by syncing Shopify product, pricing, and quantity data with Flxpoint’s Global Inventory Pool. With support for multi-location inventory and comprehensive field mappings, it ensures accurate inventory tracking across your sales channels. Happy syncing!
Order Operations
It submits orders to vendors for fulfillment and subsequently imports the shipment details, ensuring a seamless integration between order processing and shipment tracking.
Send Orders
Get Shipments