Shopify as a Source

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

📋 Phase 1: Initial Channel Setup +
Access Sales Channels
Log in to your Flxpoint account and navigate to the Sales Channels section.
Create a New Channel
Click "+" to Create Channel.
Tip: Have your Shopify store URL ready for the connection process.
Select Shopify and Name Channel
In the Channel Setup screen:
  • Search for Shopify and select it.
  • Enter a descriptive Channel Name (e.g., "Shopify Store").
  • Click Save to continue.
Start the Integration Process
After creating the channel, you’ll see "No integrations created yet." Click Get Started to launch the setup wizard.
Shopify Integration Setup
🔐 Phase 2: Authentication & Connection +
Important Note: The recommended method for connecting Shopify to Flxpoint is via OAuth2, which securely authorizes the connection without manual credential entry. Use Bearer Token or Basic Auth only if OAuth2 is unavailable (e.g., for vendors using Shopify as a source).
Select the Integration Type
In the Connect to Your Shopify Store section, select API - Shopify App (OAuth2) for secure authorization, or choose API - Bearer Token or API - Basic Auth for manual credential entry.
Connect Your Account
For OAuth2:
  • 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.
For Bearer Token or Basic Auth, if OAuth2 is unavailable (e.g., for vendors):
  • 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.
Important: Use the .myshopify.com URL (e.g., https://cool-gadgets.myshopify.com), not your custom domain (e.g., coolgadgets.com).
Authorize Access
For OAuth2, no further credentials are needed after authorization. For Bearer Token or Basic Auth:
  • 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.
Troubleshooting: If the connection fails, verify credentials, permissions, and Store URL format.
Verify Connection
Review connection details in the Flxpoint setup screen to ensure accuracy, then proceed.
Shopify API Rate Limits: Shopify enforces API rate limits to ensure platform stability. Details at Shopify API Rate Limits:
  • 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.
🔄 Phase 3: SKU Mapping & Configuration +
Set Up SKU Mapping
Configure Import Listings to align with your inventory:
  • Set new listings to Paused for review before publishing.
  • Map your internal Master SKU to Shopify’s listing SKU.
Pro Tip: Use consistent SKU naming (e.g., "PROD-123" internally and "SHOP-PROD-123" on Shopify) for easier inventory management.
Configure Integration Settings
Set up automated features:
  • 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.
Click Save to finalize.
Note: TikTok Shop integration is optional and only needed if selling on that platform.
Complete Setup
Review settings and click Confirm & Finish. In Sales Channels, start Import Listings, Get Orders, and check Sync and Link Listings and Publish Listings.
Next Steps: Run processes manually to verify sync accuracy before enabling automation.

 

 

Product Operations

Get Inventory (Primary)

Supported | Shopify - Get Inventory (Primary)

Introduction to Shopify Get Inventory (Primary)
Welcome to the Shopify Get Inventory (Primary) integration guide! This integration retrieves inventory data from Shopify into Flxpoint, fetching product lists and inventory levels for a specified location. It ensures accurate inventory tracking across your Shopify store by syncing product and variant details, including quantities, with Flxpoint’s Global Inventory Pool (GIP). Let’s get started!

The Shopify Get Inventory (Primary) integration enables you to:
  • 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.
This ensures consistent inventory tracking and management across your sales channels.

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.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 of inventory_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.
Pro Tip: Ensure the specified Location ID matches the intended Shopify inventory location for accurate quantity syncing.
Note: This integration fetches inventory for a single location per sync; repeat for additional locations as needed.

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 (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.

Mapping templates control how Shopify inventory data is imported into Flxpoint.
Interface Overview
  • 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).
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 (Primary) > 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

Info Icon 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 ...

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

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: 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
Diagnostic Tip: Missing inventory often results from unmapped SKUs or incorrect Location IDs.

Key information:
  • 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.
Pro Tip: Map SKU, Quantity, and Title, and verify Location ID for reliable inventory syncing.

Conclusion
The Shopify Get Inventory (Primary) integration streamlines inventory management by syncing Shopify product and variant 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!

 

 
 

Get Inventory (Secondary)

Supported | Shopify - Get Inventory (Secondary)

Introduction to Shopify Get Inventory (Secondary)
Welcome to the Shopify Get Inventory (Secondary) integration guide! This integration retrieves variant-level inventory updates from Shopify into Flxpoint, focusing on quantities, costs, and pricing details for a specified location. It complements the Get Inventory (Primary) integration by ensuring that variant-specific inventory data in Flxpoint’s Global Inventory Pool (GIP) stays up-to-date with Shopify. Let’s get started!

The Shopify Get Inventory (Secondary) integration enables you to:
  • 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.
This ensures precise inventory management for variants across your sales channels.

The integration follows these steps:
  • 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 of inventory_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).
Pro Tip: Use this integration alongside Get Inventory (Primary) to keep both product and variant data fully synchronized.
Note: This integration focuses on variant-level updates; ensure Get Inventory (Primary) has run to establish baseline product data.

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 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: Ensure the Location ID matches the one used in Get Inventory (Primary) for consistent data syncing.

Follow these steps:
  • 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.

Mapping templates control how Shopify variant inventory data is updated in Flxpoint.
Interface Overview
  • 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).
Mapping Options
  • 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).
SKU and Quantity Mapping Requirement
The Shopify Variant SKU and Quantity fields must be mapped to ensure proper inventory updates in Flxpoint.
  • 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.
Recommendation: Always map SKU, Quantity, Cost, MAP, and MSRP for comprehensive variant updates.
Complete Field Mappings
Below are the fields you can map from Shopify to Flxpoint, based on the provided mapping template:
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 - 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

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 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).

Troubleshoot issues with these steps:
  • 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
Diagnostic Tip: Missing updates often result from unmapped SKU or Quantity fields, or incorrect Location IDs.

Key information:
  • 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.
Pro Tip: Map SKU, Quantity, Cost, MAP, and MSRP, and verify Location ID for reliable inventory updates.

Conclusion
The Shopify Get Inventory (Secondary) integration ensures variant-level inventory data in Flxpoint stays aligned with Shopify, updating quantities, costs, and pricing details. With support for multi-location inventory and targeted mappings, it enhances inventory accuracy for your sales channels. Happy syncing!

 

 
 


Order Operations

Send Fulfillment Requests

Supported | Shopify - Send Fulfillment Requests

Introduction to Shopify Send Fulfillment Requests
Welcome to the Shopify Send Fulfillment Requests integration guide! This integration allows Flxpoint to send fulfillment requests to Shopify, enabling Shopify to process and fulfill orders with accurate details such as billing/shipping addresses, line items, and order notes. It ensures seamless communication between Flxpoint and Shopify for efficient order fulfillment across your sales channels. Let’s get started!

The Shopify Send Fulfillment Requests integration enables you to:
  • 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.
This ensures efficient order fulfillment and accurate data synchronization between Flxpoint and Shopify.

The integration follows these steps:
  • 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.
Pro Tip: Ensure accurate mapping of billing and shipping addresses to avoid fulfillment delays.
Note: The integration requires an existing order in Shopify; ensure orders are imported via Shopify Get Orders integration first.

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 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).
Note: Verify the Location ID in Shopify to ensure fulfillment requests are sent to the correct location.

Follow these steps:
  • 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.

Mapping templates control how Flxpoint order data is sent to Shopify for fulfillment requests.
Interface Overview
  • 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).
Mapping Options
  • 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).
Line Item Mapping Requirement
The Shopify Line Item SKU and Fulfillable Quantity fields must be mapped to ensure proper fulfillment request processing.
  • 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.
Recommendation: Always map SKU, Fulfillable Quantity, Billing Address, and Shipping Address fields for reliable fulfillment requests.
Complete Field Mappings
Below are the fields you can map from Flxpoint to Shopify, based on the provided mapping template:
Order Note Attributes Fields
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)
Billing Address Fields
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
Discount Code Fields
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
Line Item Fields
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
Order Fields
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
Shipping Address Fields
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

Flxpoint supports Shopify’s multi-location inventory for accurate fulfillment requests:
  • 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.
Pro Tip: Configure multiple integration jobs with different Location IDs to handle fulfillment across all Shopify locations.

Be aware of these constraints:
  • 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.

Troubleshoot issues with these steps:
  • 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.
Diagnostic Tip: Fulfillment failures often result from unmapped SKU/Quantity fields or missing orders in Shopify.

Key information:
  • 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.
Pro Tip: Map SKU, Fulfillable Quantity, Billing Address, and Shipping Address, and verify Location ID for reliable fulfillment requests.

Conclusion
The Shopify Send Fulfillment Requests integration streamlines order fulfillment by enabling Flxpoint to send detailed fulfillment requests to Shopify. With support for multi-location inventory and comprehensive field mappings, it ensures accurate and efficient order processing across your sales channels. Happy fulfilling!

 

 
 

Get Shipments

Supported | Shopify - Get Shipments

Introduction to Shopify Get Shipments
Welcome to the Shopify Get Shipments integration guide! This integration retrieves shipment data from Shopify into Flxpoint, syncing fulfillment details such as tracking numbers, carriers, and shipment statuses. It ensures that Flxpoint’s records reflect the latest shipping information for orders, enabling accurate tracking and order management across your sales channels. Let’s get started!

The Shopify Get Shipments integration enables you to:
  • 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.
This ensures consistent shipment tracking and management across your sales channels.

The integration follows these steps:
  • 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.
Pro Tip: Ensure the specified Location ID matches the intended Shopify fulfillment location for accurate shipment retrieval.
Note: This integration requires existing fulfillments in Shopify; ensure orders are fulfilled or synced via Shopify Sync Orders integration.

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 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).
Note: Verify the Location ID in Shopify to ensure shipments are fetched for the correct location.

Follow these steps:
  • 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.

Mapping templates control how Shopify shipment data is imported into Flxpoint.
Interface Overview
  • 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).
Mapping Options
  • 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”).
Tracking Number Mapping Requirement
The Shopify Fulfillment Tracking Number field must be mapped to ensure proper shipment tracking in Flxpoint.
  • 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.
Recommendation: Always map Tracking Number, Tracking URL, Carrier, and Shipped At for reliable shipment tracking.
Complete Field Mappings
Below are the fields you can map from Shopify to Flxpoint, based on the provided mapping template:
Shipment Fields
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

Flxpoint supports Shopify’s multi-location inventory for accurate shipment retrieval:
  • 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.
Pro Tip: Use Location ID filtering to focus on specific fulfillment locations and reduce sync time.

Be aware of these constraints:
  • 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.

Troubleshoot issues with these steps:
  • 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
Diagnostic Tip: Missing shipments often result from unmapped Tracking Number fields or incorrect Location IDs.

Key information:
  • 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.
Pro Tip: Map Tracking Number, Tracking URL, Carrier, and Shipped At, and verify Location ID for reliable shipment syncing.

Conclusion
The Shopify Get Shipments integration streamlines shipment tracking by syncing Shopify fulfillment data with Flxpoint. With support for multi-location inventory and detailed field mappings, it ensures accurate shipment records across your sales channels. Happy tracking!