Shopify is a popular eCommerce platform that allows businesses to manage online stores. Integrating Shopify as a source in Flxpoint enables the seamless synchronization of products, inventory, and orders between the two platforms. This integration helps streamline order processing, product listings, and inventory updates, ensuring that your Shopify store is always in sync with your Flxpoint account.
How to connect
- Search for Shopify and select it.
- Enter a descriptive Channel Name (e.g., "Shopify Store").
- Click Save to continue.

- Enter your Store URL (e.g., https://your-store-name.myshopify.com). Find this in Shopify Admin under Settings > Domains or in your browser’s address bar when logged into Shopify Admin.
- Click Initiate OAuth2 Flow and follow prompts to log in to Shopify and grant Flxpoint access.
- Log in to Shopify Admin at https://www.shopify.com/login.
- Go to Apps > Develop apps for your store and enable custom app development if prompted.
- Click Create an app, name it (e.g., "Flxpoint Integration"), and create it.
- In API Credentials, generate an Admin API access token with permissions for products, orders, and inventory.
- Copy the API Key, API Secret Key, and Admin API access token.
- Set a Connection Name (e.g., "Shopify Connection #1").
- For Bearer Token, paste the Admin API access token into the Token field.
- For Basic Auth, enter the API Key and API Secret Key.
- Input your Store URL.
- Click Test Connection and then Continue if successful.
- REST API: 2 requests/sec, 4 requests/sec for Shopify Plus.
- GraphQL: 50 points/sec.
- OAuth2: Exempt from rate limits; optimize with Flxpoint sync schedules.
- Set new listings to Paused for review before publishing.
- Map your internal Master SKU to Shopify’s listing SKU.
- Publish Listings: Shopify uses GraphQL; map categories to global IDs from Shopify Product Taxonomy (e.g., "Consumer Electronics"). Adjust settings like "Truncate Title to 255."
- Order Sync: Select statuses (e.g., Open) and time range for Get Orders. Orders with or without a Location ID are saved unless disabled in Advance Config.
- TikTok Shop (Optional): In Shopify Admin, install a TikTok Shop app, connect your store, and verify listings can be published via Flxpoint.
Product Operations
Get Inventory (Primary)
- Fetch product lists and inventory levels from Shopify for a specified location.
- Sync inventory quantities with Flxpoint’s Global Inventory Pool (GIP) for centralized management.
- Support multi-location inventory by associating quantities with the correct Shopify Location ID.
- Map Shopify product and variant fields to Flxpoint inventory fields for accurate data integration.
- 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.json
retrieves the product list for all locations. -
3 Extracting Inventory Item IDs: Creates a list of
inventory_item_id
values from the fetched products. -
4 Retrieving Inventory Levels: A GET call to
/admin/api/{version}/inventory_levels.json?location_ids=xxxxxx
fetches inventory levels for the specified location using the list ofinventory_item_id
. - 5 Mapping Data: Maps Shopify product and variant data to Flxpoint inventory fields using a mapping template.
- 6 Saving Quantities: Updates quantities in Flxpoint’s Global Inventory Pool (GIP) based on the retrieved inventory levels.
- 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).
- 1 Add the Integration: Go to Channels > Shopify > Integrations, select “Get Inventory (Primary).”
- 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.
- Screen labeled “Get Inventory (Primary)” at the top; name your template (e.g., “Shopify Get Inventory Primary 1”).
- Buttons: Delete, Duplicate, Save Mapping.
- Sections: Inventory Parent Fields (e.g., Title, Description), Inventory Variant Fields (e.g., SKU, Quantity).
- Columns: Shopify fields (left, e.g., Shopify Product Title), Flxpoint fields (right, e.g., Title).
- 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).
- 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 (Primary) > Field Mapping, map Shopify Variant SKU to Flxpoint SKU, save, and re-run sync.
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 |
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:
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 |
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 |
- 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.
- 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.
- Inventory Not Syncing: Verify the Location ID is correct and matches a valid Shopify location.
- Missing Quantities: Ensure the Shopify Variant Quantity field is mapped to Flxpoint Quantity 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
- Date: As of 09:19 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.
Get Inventory (Secondary)
- Fetch variant-level inventory updates from Shopify for a specified location.
- Update quantities, costs, and pricing details in Flxpoint’s Global Inventory Pool (GIP).
- Support multi-location inventory by associating updates with the correct Shopify Location ID.
- Map Shopify variant fields to Flxpoint inventory fields for accurate data synchronization.
- 1 Connecting to Shopify: Establish a connection using OAuth2 authentication to access your Shopify store.
-
2 Fetching Variant List: A GET call to
/admin/api/{version}/products.json
retrieves the product list, including variants, for all locations. -
3 Extracting Inventory Item IDs: Creates a list of
inventory_item_id
values from the fetched variants. -
4 Retrieving Inventory Levels: A GET call to
/admin/api/{version}/inventory_levels.json?location_ids=xxxxxx
fetches inventory levels for the specified location using the list ofinventory_item_id
. - 5 Mapping Data: Maps Shopify variant data (e.g., Quantity, Cost, MSRP) to Flxpoint inventory fields using a mapping template.
- 6 Updating Quantities and Pricing: Updates variant quantities, costs, and pricing details in Flxpoint’s Global Inventory Pool (GIP).
- 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 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).
- 1 Add the Integration: Go to Channels > Shopify > Integrations, select “Get Inventory (Secondary).”
- 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 variants (see Mapping Template Details).
- 5 Run the Integration: Start with Run Sync or schedule automatic syncs.
- Screen labeled “Get Inventory (Secondary)” at the top; name your template (e.g., “Shopify Get Inventory Secondary 1”).
- Buttons: Delete, Duplicate, Save Mapping.
- Sections: Inventory Variant Fields (e.g., Quantity, SKU, Cost).
- Columns: Shopify fields (left, e.g., Shopify Variant Quantity), Flxpoint fields (right, e.g., Quantity).
- Don't Map: Ignore the field; no data is updated in Flxpoint.
- Set To Empty: Clear the field in Flxpoint.
- Field: Map a Shopify field to a Flxpoint field (e.g., Shopify Variant Quantity to Flxpoint Quantity).
- Value: Set a static value (e.g., Cost to “10”).
- Mapping Set: Apply a predefined mapping set for complex mappings.
- Rules: Apply conditional logic (e.g., update Quantity only if greater than 0).
- Required Fields: SKU identifies variants, and Quantity updates inventory levels.
-
Error Scenario: Unmapped SKU or Quantity may cause inventory sync failures:
Invalid request: Missing required fields 'SKU' or 'Quantity' for inventory sync
- Fix: Go to Channels > Shopify > Templates > Get Inventory (Secondary) > Field Mapping, map Shopify Variant SKU to Flxpoint SKU and Shopify Variant Quantity to Flxpoint Quantity, save, and re-run sync.
Shopify Field | Maps To | Data Type | Example | Purpose | Status |
---|---|---|---|---|---|
Shopify Variant - SKU | Flxpoint SKU | Text | variant-sku-001 | Identifies the variant | Required |
Shopify Variant - Quantity | Flxpoint Quantity | Number | 50 | Updates inventory quantity | Required |
Shopify Variant - Cost | Flxpoint Cost | Number | $20 | Updates product cost | Supported |
Shopify Variant - Compare At Price | Flxpoint MAP | Number | $45 | Updates minimum advertised price | Supported |
Shopify Variant - Compare At Price | Flxpoint MSRP | Number | $50 | Updates manufacturer’s suggested retail price | Supported |
Shopify Variant - Title | Flxpoint Custom Field | Text | Blue T-Shirt - Medium | Sets variant title as custom field | Supported |
Shopify Variant - Barcode | Flxpoint Custom Field | Text | 012345678905 | Sets barcode as custom field | 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 - ID | Flxpoint Custom Field | Text | 987654321 | Sets variant ID as custom field | Supported |
Shopify Variant - Inventory Item ID | Flxpoint Custom Field | Number | 456789123 | Sets inventory item ID as custom field | Supported |
Shopify Variant - Position | Flxpoint Custom Field | Number | 1 | Sets variant position as custom field | Supported |
Shopify Variant - Price | Flxpoint Custom Field | Number | $30 | Sets selling price as custom field | Supported |
Shopify Variant - Weight | Flxpoint Custom Field | Number | 0.5 | Sets variant weight as custom field | Supported |
Shopify Variant - Grams | Flxpoint Custom Field | Number | 500 | Sets weight in grams as custom field | Supported |
- 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.
- 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 updates.
- API Rate Limits: Shopify API rate limits may affect large inventory syncs; monitor usage to avoid interruptions.
- Variant Focus: This integration updates variant-level data only; parent product updates require Get Inventory (Primary).
- Inventory Not Updating: Verify the Location ID is correct and matches a valid Shopify location.
- Missing Quantities or Costs: Ensure Shopify Variant Quantity, Cost, MAP, and MSRP fields are mapped in the 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
- Date: As of 08:59 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.
Order Operations
Send Fulfillment Requests
- Send fulfillment requests from Flxpoint to Shopify for order processing.
- Include detailed order information such as billing/shipping addresses, line items, and order notes.
- Support multi-location fulfillment by specifying the correct Shopify Location ID.
- Map Flxpoint order data to Shopify fields for accurate fulfillment request creation.
- 1 Connecting to Shopify: Establish a connection using OAuth2 authentication to access your Shopify store.
- 2 Preparing Order Data: Flxpoint gathers order details, including billing/shipping addresses, line items, and fulfillment request information.
- 3 Mapping Data: Maps Flxpoint order data to Shopify fields (e.g., Billing Address, Line Items) using a mapping template.
-
4 Sending Fulfillment Request: A POST request to
/admin/api/{version}/fulfillment_requests.json
sends the fulfillment request for a specified order ID to Shopify. - 5 Specifying Location: Includes the Shopify Location ID to ensure the request is routed to the correct fulfillment location.
- 6 Confirmation: Shopify processes the fulfillment request, and Flxpoint logs the request status for tracking.
- Connection: Select your Shopify OAuth connection (e.g., “Shopify Connection API - Shopify App (OAuth2)”).
- Location ID: Specify the Shopify inventory location ID for routing fulfillment requests (required).
- Mapping Template: Define how Flxpoint order data maps to Shopify fields (see Mapping Template Details).
- Sync Frequency: Run manually or schedule syncs (e.g., hourly to process new orders).
- 1 Add the Integration: Go to Channels > Shopify > Integrations, select “Send Fulfillment Requests.”
- 2 Connect to Shopify: Select an existing Shopify OAuth connection or set up a new one.
-
3 Configure Settings:
- Specify the Location ID for fulfillment routing.
- Configure sync frequency (e.g., hourly).
- 4 Create Mapping Template: Configure field mappings for order data (see Mapping Template Details).
- 5 Run the Integration: Start with Run Sync or schedule automatic syncs.
- Screen labeled “Send Fulfillment Requests” at the top; name your template (e.g., “Shopify Send Fulfillment Requests 1”).
- Buttons: Delete, Duplicate, Save Mapping.
- Sections: Order Note Attributes, Billing Address, Discount Code, Line Item, Order, Shipping Address.
- Columns: Flxpoint fields (left, e.g., Fulfillment Request Number), Shopify fields (right, e.g., Note).
- Don't Map: Ignore the field; no data is sent to Shopify.
- Set To Empty: Clear the field in Shopify.
- Field: Map a Flxpoint field to a Shopify field (e.g., Fulfillment Request Quantity to Shopify Line Item Fulfillable Quantity).
- Value: Set a static value (e.g., Note to “Urgent Fulfillment”).
- Mapping Set: Apply a predefined mapping set for complex mappings.
- Rules: Apply conditional logic (e.g., send only if Fulfillment Request Total Cost exceeds $100).
- Required Fields: SKU identifies items, and Fulfillable Quantity specifies the quantity to fulfill.
-
Error Scenario: Unmapped SKU or Fulfillable Quantity may cause fulfillment request failures:
Invalid request: Missing required fields 'SKU' or 'Fulfillable Quantity' for fulfillment request
- Fix: Go to Channels > Shopify > Templates > Send Fulfillment Requests > Field Mapping, map Fulfillment Request Item SKU to Shopify Line Item SKU and Fulfillment Request Item Quantity to Shopify Line Item Fulfillable Quantity, save, and re-run sync.
Flxpoint Field | Maps To | Data Type | Example | Purpose | Status |
---|---|---|---|---|---|
Custom Fields (2) | Shopify Order Note Attributes - Custom Fields | Text | priority: high | Adds custom attributes to order notes | Supported (Up to 2) |
Flxpoint Field | Maps To | Data Type | Example | Purpose | Status |
---|---|---|---|---|---|
Billing Address - Address Line 1 | Shopify Billing Address - Address 1 | Text | 123 Main St | Sets billing address line 1 | Supported |
Billing Address - Address Line 2 | Shopify Billing Address - Address 2 | Text | Apt 4B | Sets billing address line 2 | Supported |
Billing Address - City | Shopify Billing Address - City | Text | New York | Sets billing city | Supported |
Billing Address - Company Name | Shopify Billing Address - Company | Text | Acme Corp | Sets billing company name | Supported |
Billing Address - Country | Shopify Billing Address - Country | Text | United States | Sets billing country | Supported |
Billing Address - Country Code | Shopify Billing Address - Country Code | Text | US | Sets billing country code | Supported |
Billing Address - Email | Shopify Billing Address - Email | Text | john.doe@example.com | Sets billing email | Supported |
Billing Address - First Name | Shopify Billing Address - Name | Text | John | Sets billing first name | Supported |
Billing Address - Full Name | Shopify Billing Address - Name | Text | John Doe | Sets billing full name | Supported |
Billing Address - Last Name | Shopify Billing Address - Name | Text | Doe | Sets billing last name | Supported |
Billing Address - Phone | Shopify Billing Address - Phone | Text | 555-123-4567 | Sets billing phone number | Supported |
Billing Address - Postal Code | Shopify Billing Address - Zip | Text | 10001 | Sets billing postal code | Supported |
Billing Address - State | Shopify Billing Address - Province | Text | New York | Sets billing state | Supported |
Billing Address - State Code | Shopify Billing Address - Province Code | Text | NY | Sets billing state code | Supported |
Flxpoint Field | Maps To | Data Type | Example | Purpose | Status |
---|---|---|---|---|---|
Channel Invoice - Discount Total | Shopify Discount Code - Amount | Number | $10 | Sets discount amount | Supported |
Channel Invoice - Invoice Number | Shopify Discount Code - Code | Text | DISCOUNT10 | Sets discount code | Supported |
Channel Invoice - Discount Total | Shopify Discount Code - Type | Text | fixed_amount | Sets discount type | Supported |
Flxpoint Field | Maps To | Data Type | Example | Purpose | Status |
---|---|---|---|---|---|
Fulfillment Request Item - Subtotal | Shopify Line Item - Price | Number | $30 | Sets line item price | Supported |
Fulfillment Request Item - Quantity | Shopify Line Item - Fulfillable Quantity | Number | 2 | Sets quantity to fulfill | Required |
Fulfillment Request Item - Bin Location | Shopify Line Item - Fulfillment Service | Text | warehouse-1 | Sets fulfillment service | Supported |
Fulfillment Request Item - Quantity | Shopify Line Item - Fulfillment Status | Text | pending | Sets fulfillment status | Supported |
Fulfillment Request Item - Title | Shopify Line Item - Gift Card | Text | false | Indicates if item is a gift card | Supported |
Fulfillment Request Item - PO Line Item # | Shopify Line Item - ID | Number | 1001 | Sets line item ID | Supported |
Fulfillment Request Item - Note | Shopify Line Item - Properties | Text | color: blue | Sets line item properties | Supported |
Fulfillment Request Item - SKU | Shopify Line Item - Product Exists | Text | true | Indicates if product exists | Supported |
Fulfillment Request Item - SKU | Shopify Line Item - Product ID | Text | prod-123 | Sets product ID | Supported |
Fulfillment Request Item - Quantity | Shopify Line Item - Quantity | Number | 2 | Sets total quantity | Supported |
Fulfillment Request Item - Quantity | Shopify Line Item - Requires Shipping | Text | true | Indicates if shipping is required | Supported |
Fulfillment Request Item - SKU | Shopify Line Item - SKU | Text | item-sku-001 | Sets line item SKU | Required |
Fulfillment Request Item - Title | Shopify Line Item - Variant Title | Text | Blue T-Shirt - Medium | Sets variant title | Supported |
Fulfillment Request Item - MPN | Shopify Line Item - Vendor | Text | BrandX | Sets vendor information | Supported |
Flxpoint Field | Maps To | Data Type | Example | Purpose | Status |
---|---|---|---|---|---|
Billing Address - Email | Shopify Order - Email | Text | john.doe@example.com | Sets order email | Supported |
Channel Invoice - Total | Shopify Order - Financial Status | Text | paid | Sets financial status | Supported |
Fulfillment Request - Total Weight (lbs) | Shopify Order - Inventory Behaviour | Text | decrement_obeying_policy | Sets inventory behavior | Supported |
Fulfillment Request - Note | Shopify Order - Note | Text | Urgent Fulfillment | Sets order note | Supported |
Billing Address - Phone | Shopify Order - Phone | Text | 555-123-4567 | Sets order phone number | Supported |
Fulfillment Request - Sent At | Shopify Order - Send Fulfillment Receipt | Text | false | Controls fulfillment receipt notification | Supported |
Channel Invoice - Receipt Sent At | Shopify Order - Send Order Receipt | Text | false | Controls order receipt notification | Supported |
Source Shipping Method - Method | Shopify Order - Shipping Method Title | Text | Standard Shipping | Sets shipping method title | Supported |
Fulfillment Request - Estimated Shipping Cost | Shopify Order - Shipping Price | Number | $5 | Sets shipping price | Supported |
Fulfillment Request - Fulfillment Request Number | Shopify Order - Tags | Text | FR-001 | Sets order tags | Supported |
Channel Invoice - Tax Cost | Shopify Order - Total Tax | Number | $2 | Sets total tax amount | Supported |
Flxpoint Field | Maps To | Data Type | Example | Purpose | Status |
---|---|---|---|---|---|
Shipping Address - Address Line 1 | Shopify Shipping Address - Address 1 | Text | 456 Oak St | Sets shipping address line 1 | Supported |
Shipping Address - Address Line 2 | Shopify Shipping Address - Address 2 | Text | Suite 5C | Sets shipping address line 2 | Supported |
Shipping Address - City | Shopify Shipping Address - City | Text | Los Angeles | Sets shipping city | Supported |
Shipping Address - Company Name | Shopify Shipping Address - Company | Text | XYZ Inc | Sets shipping company name | Supported |
Shipping Address - Country | Shopify Shipping Address - Country | Text | United States | Sets shipping country | Supported |
Shipping Address - Country Code | Shopify Shipping Address - Country Code | Text | US | Sets shipping country code | Supported |
Shipping Address - Latitude | Shopify Shipping Address - Latitude | Text | 34.0522 | Sets shipping latitude | Supported |
Shipping Address - Longitude | Shopify Shipping Address - Longitude | Text | -118.2437 | Sets shipping longitude | Supported |
Shipping Address - First Name | Shopify Shipping Address - Name | Text | Jane | Sets shipping first name | Supported |
Shipping Address - Full Name | Shopify Shipping Address - Name | Text | Jane Smith | Sets shipping full name | Supported |
Shipping Address - Last Name | Shopify Shipping Address - Name | Text | Smith | Sets shipping last name | Supported |
Shipping Address - Phone | Shopify Shipping Address - Phone | Text | 555-987-6543 | Sets shipping phone number | Supported |
Shipping Address - Postal Code | Shopify Shipping Address - Zip | Text | 90001 | Sets shipping postal code | Supported |
Shipping Address - State | Shopify Shipping Address - Province | Text | California | Sets shipping state | Supported |
Shipping Address - State Code | Shopify Shipping Address - Province Code | Text | CA | Sets shipping state code | Supported |
- Location ID Requirement: Specify a Location ID in Flxpoint to route fulfillment requests to the correct Shopify location. Refer to Shopify’s guide on managing locations.
- Single Location Per Request: The integration sends fulfillment requests for one location per job, using the specified Location ID in the API call.
- Single Location Per Request: Fulfillment requests are sent for one location per job; multiple jobs are needed for multiple locations.
- Order Dependency: Requires an existing order in Shopify; orders must be imported via Shopify Get Orders integration first.
- API Rate Limits: Shopify API rate limits may affect large fulfillment request batches; monitor usage to avoid interruptions.
- Custom Fields Limit: Order Note Attributes support up to 2 custom fields.
- Fulfillment Request Not Sent: Verify the Location ID is correct and matches a valid Shopify location.
- Missing Line Items: Ensure Shopify Line Item SKU and Fulfillable Quantity are mapped in the template.
- API Errors: Check for Shopify API rate limit issues; reduce sync frequency if needed.
-
Order Not Found: Confirm the order exists in Shopify; if not, import it using Shopify Get Orders integration:
Error: Order not found in Shopify for fulfillment request
- Address Issues: Verify billing and shipping address mappings to ensure all required fields are populated.
- Date: As of 09:03 PM -04, May 29, 2025, this integration is operational.
- Required Fields: Line Item SKU and Fulfillable Quantity must be mapped.
- API Limits: Monitor Shopify API rate limits to avoid sync interruptions.
Get Shipments
- Fetch shipment data from Shopify, including tracking numbers, carriers, and shipment statuses.
- Sync fulfillment details with Flxpoint for centralized order tracking.
- Support multi-location inventory by retrieving shipments for specific Shopify locations.
- Map Shopify shipment fields to Flxpoint fields for accurate data integration.
- 1 Connecting to Shopify: Establish a connection using OAuth2 authentication to access your Shopify store.
-
2 Fetching Fulfillment Data: A GET call to
/admin/api/{version}/fulfillments.json
retrieves fulfillment records for orders, optionally filtered by Location ID. - 3 Retrieving Order Details: Fetches associated order data (e.g., shipping cost, order status) linked to the fulfillments.
- 4 Mapping Data: Maps Shopify fulfillment and order data to Flxpoint shipment fields (e.g., Tracking Number, Carrier) using a mapping template.
- 5 Updating Flxpoint Records: Updates Flxpoint with the retrieved shipment data for tracking and order management.
- Connection: Select your Shopify OAuth connection (e.g., “Shopify Connection API - Shopify App (OAuth2)”).
- Location ID: Specify the Shopify inventory location ID to retrieve shipments (optional; if omitted, fetches all locations).
- Mapping Template: Define how Shopify shipment fields map to Flxpoint fields (see Mapping Template Details).
- Sync Frequency: Run manually or schedule syncs (e.g., daily at 6 AM UTC).
- 1 Add the Integration: Go to Channels > Shopify > Integrations, select “Get Shipments.”
- 2 Connect to Shopify: Select an existing Shopify OAuth connection or set up a new one.
-
3 Configure Settings:
- Specify the Location ID for shipment retrieval (optional).
- Configure sync frequency (e.g., daily at 6 AM UTC).
- 4 Create Mapping Template: Configure field mappings for shipment data (see Mapping Template Details).
- 5 Run the Integration: Start with Run Sync or schedule automatic syncs.
- Screen labeled “Get Shipments” at the top; name your template (e.g., “Shopify Get Shipments 1”).
- Buttons: Delete, Duplicate, Save Mapping.
- Sections: Shipment Fields (e.g., Carrier, Tracking Number).
- Columns: Shopify fields (left, e.g., Shopify Fulfillment Tracking Number), Flxpoint fields (right, e.g., Tracking Number).
- Don't Map: Ignore the field; no data is imported to Flxpoint.
- Set To Empty: Clear the field in Flxpoint.
- Field: Map a Shopify field to a Flxpoint field (e.g., Shopify Fulfillment Tracking Number to Flxpoint Tracking Number).
- Value: Set a static value (e.g., Carrier to “UPS”).
- Mapping Set: Apply a predefined mapping set for complex mappings.
- Rules: Apply conditional logic (e.g., map Shipped At only if Status is “shipped”).
- Required Field: Tracking Number uniquely identifies shipments.
-
Error Scenario: Unmapped Tracking Number may cause shipment sync failures:
Invalid request: Missing required field 'Tracking Number' for shipment sync
- Fix: Go to Channels > Shopify > Templates > Get Shipments > Field Mapping, map Shopify Fulfillment Tracking Number to Flxpoint Tracking Number, save, and re-run sync.
Shopify Field | Maps To | Data Type | Example | Purpose | Status |
---|---|---|---|---|---|
Shopify Fulfillment - Tracking Company | Flxpoint Carrier | Text | UPS | Sets shipment carrier | Supported |
Shopify Order - Shipping Method Title | Flxpoint Method | Text | Standard Shipping | Sets shipping method | Supported |
Shopify Fulfillment - Name | Flxpoint Note | Text | Fulfillment #1001 | Sets shipment note | Supported |
Shopify Fulfillment - Created At | Flxpoint Shipped At | Date | 2025-05-28T14:00:00Z | Sets shipment date | Supported |
Shopify Order - Shipping Cost | Flxpoint Shipping Cost | Number | $5 | Sets shipping cost | Supported |
Shopify Fulfillment - Tracking Number | Flxpoint Tracking Number | Text | 1Z9999W999999999 | Sets tracking number | Required |
Shopify Fulfillment - Tracking URL | Flxpoint Tracking URL | Text | https://ups.com/track | Sets tracking URL | Supported |
Shopify Fulfillment - ID | Flxpoint Reference Identifier | Number | 1001 | Sets shipment identifier | Supported |
Shopify Fulfillment - Location ID | Flxpoint Location ID | Number | 123456789 | Sets fulfillment location ID | Supported |
Shopify Fulfillment - Order ID | Flxpoint Order ID | Number | 987654321 | Sets associated order ID | Supported |
Shopify Fulfillment - Service | Flxpoint Fulfillment Service | Text | warehouse-1 | Sets fulfillment service | Supported |
Shopify Fulfillment - Shipment Status | Flxpoint Shipment Status | Text | in_transit | Sets shipment status | Supported |
Shopify Fulfillment - Status | Flxpoint Status | Text | shipped | Sets fulfillment status | Supported |
Shopify Fulfillment - Updated At | Flxpoint Updated At | Date | 2025-05-29T09:00:00Z | Sets last update date | Supported |
- Location ID Filtering: Specify a Location ID in Flxpoint to fetch shipments for that location. Refer to Shopify’s guide on managing locations.
- All Locations Option: If no Location ID is specified, the integration retrieves shipments from all locations.
- Fulfillment Dependency: Requires existing fulfillments in Shopify; orders must be fulfilled or synced via Shopify Sync Orders integration.
- API Rate Limits: Shopify API rate limits may affect large shipment syncs; monitor usage to avoid interruptions.
- Location-Specific Data: Shipments are tied to specific locations; ensure correct Location ID usage to avoid missing data.
- Shipments Not Syncing: Verify the Location ID is correct and matches a valid Shopify location, or remove it to fetch all locations.
- Missing Tracking Information: Ensure Shopify Fulfillment Tracking Number and Tracking URL are mapped in the template.
- API Errors: Check for Shopify API rate limit issues; reduce sync frequency if needed.
-
No Shipments Found: Confirm fulfillments exist in Shopify; if not, ensure orders are fulfilled or synced:
Warning: No fulfillments found for specified orders
- Date: As of 09:06 PM -04, May 29, 2025, this integration is operational.
- Required Fields: Tracking Number must be mapped.
- API Limits: Monitor Shopify API rate limits to avoid sync interruptions.