Shopify is a leading eCommerce platform that allows businesses to sell products online and manage their sales channels efficiently. Integrating Shopify into Flxpoint as a channel allows you to automate order processing, inventory syncing, and product publishing between Flxpoint and Shopify. It helps streamline operations, ensuring that your product data and inventory levels are always up-to-date across your sales platforms.
How to Connect
📋 Phase 1: Initial Channel Setup
+
Access Sales Channels
Log in to your Flxpoint account and navigate to Sales Channels.
Create a New Channel
Click "+" to Create Channel.
Tip: Ensure you 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 Channel Name (e.g., "Shopify Store").
- Click Save & Next.
🔐 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).
Choose Connection Method
In the Connect to Your Shopify Store section:
- Recommended: Select API - Shopify App (OAuth2) and click Initiate OAuth2 Flow to securely authorize Flxpoint.
- Alternatively, choose API - Bearer Token or API - Basic Auth for manual credential entry (required for vendors using Shopify as a source).
Connect via OAuth2
If using OAuth2:
- Enter your Store URL (e.g., https://your-store-name.myshopify.com). Find this in your Shopify Admin under Settings > Domains or in your browser’s address bar when logged into Shopify Admin.
- Follow the OAuth2 prompts to log in to Shopify and grant Flxpoint access.
- No API keys or tokens are required for OAuth2.
Important: Use the .myshopify.com URL (e.g., https://cool-gadgets.myshopify.com), not your custom domain (e.g., coolgadgets.com).
Obtain API Credentials (Bearer Token or Basic Auth)
If OAuth2 is unavailable, create a custom app:
- Log in to Shopify Admin at https://www.shopify.com/login.
- Go to Apps > Develop apps for your store (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.
- Note your Store URL (e.g., https://your-store-name.myshopify.com).
Enter Credentials (Bearer Token or Basic Auth)
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 (e.g., https://your-store-name.myshopify.com).
- Click Test Connection, then Save & Next if successful.
Troubleshooting: If the connection fails, verify credentials, permissions, and ensure the Store URL uses the .myshopify.com format.
Shopify API Rate Limits: Shopify enforces API rate limits to ensure platform stability. Details are available at Shopify API Rate Limits:
- REST API: 2 requests/sec (standard), 4 requests/sec (Shopify Plus).
- GraphQL: 50 points/sec (standard plans).
- OAuth2: Exempt from rate limits; optimize with Flxpoint sync schedules.
🔄 Phase 3: Configuration & Integration
+
Configure Import Listings
For Import Listings:
- Set new listings to Paused to review before publishing.
- Configure Master SKU to align with your inventory.
Set Up Publish Listings
For Publish Listings:
- Shopify uses GraphQL; Category requires a global ID from Shopify Product Taxonomy.
- Map internal categories (e.g., "Consumer Electronics") to valid global IDs in your template.
- Adjust settings like "Truncate Title to 255" as needed.
Configure Order Sync
For Get Orders:
- Select statuses (e.g., Open) and time range for order imports.
- Location ID Note: Orders with or without a Location ID are saved unless disabled in Advance Config.
Connect TikTok Shop (Optional)
To integrate with TikTok Shop:
- In Shopify Admin, install a Shopify app/plugin that supports TikTok Shop integration (e.g., TikTok Shop app).
- Follow the app’s instructions to connect your Shopify store to TikTok Shop.
- Verify the integration by ensuring listings can be published to TikTok Shop via the Shopify channel in Flxpoint.
Note: TikTok Shop integration is optional and only needed if you plan to sell on that platform.
Click Confirm to proceed with configuration settings.
✅ Phase 4: Finalize and Launch
+
Review and Enable Processes
In the Channel Created screen:
- Review settings and enable processes (e.g., import listings).
- Click Confirm & Finish.
Start Syncing
In Sales Channels:
- Start Import Listings to sync products.
- Start Get Orders to manage orders.
- Check Sync and Link Listings and Publish Listings.
Pro Tip: Run each process manually first to verify products and orders sync correctly before enabling automation.
Listing Operations
Import Listings
Supported | Shopify - Import Listings
Introduction to Shopify Import Listings
Welcome to the Shopify Import Listings integration guide! This integration allows you to bring product listings from your Shopify store into Flxpoint, creating or updating listings based on Shopify data. It ensures centralized inventory management across multiple channels. Let’s get started!
The Shopify Import Listings integration enables you to:
- Centralize inventory by importing Shopify listings into Flxpoint to manage across multiple channels.
- Define Master SKUs in Flxpoint to connect Shopify listings with fulfillment sources.
- Control import behavior with options to pause new listings for review.
- Support variants by importing both parent products and variants, including fields like price, quantity, and metafields.
The integration follows these steps:
- 1 Connecting to Shopify: Establish a connection using API credentials or OAuth2 authentication to access your Shopify store.
- 2 Fetching Product Data: A GET call to the Shopify /admin/api/{version}/products.json endpoint retrieves product data, including variants.
- 3 Defining Master SKU: Maps a Shopify field (e.g., Variant Barcode or SKU) to Flxpoint’s Master SKU for unique identification.
- 4 Importing Listings: Creates or updates listings in Flxpoint based on Shopify data, following selected Product & Listing Management settings.
- 5 Handling Variants: Imports variant-specific fields like price, quantity, and metafields into Flxpoint.
- 6 Pausing New Listings (Optional): Sets newly imported listings to "Paused" status to allow review before syncing with sources.
Pro Tip: Enable "Pause New Listings" to review and link listings to sources before syncing.
Note: This integration does not support scheduling; run it manually to import listings.
Customize the integration with these settings:
- Connection: Select your Shopify store connection (e.g., "Shopify Connection API - Shopify App (OAuth2)").
- Set New Listings to Paused: Enable to pause newly imported listings for review before syncing.
- Master SKU: Choose a Shopify field (e.g., Variant Barcode or SKU) to populate Flxpoint’s Master SKU.
- Product & Listing Management: Select import behavior: "Create products & listings only," "Create new products only," or "Create and update products & listings."
Note: Choose a Master SKU field with unique values to avoid import errors.
Follow these steps:
- 1 Add the Integration: Go to Channels > Shopify > Integrations, select "Import Listings."
- 2 Connect to Shopify: Use existing Shopify credentials or set up a new connection via OAuth2 authentication.
-
3 Configure Settings:
- Enable "Set New Listings to Paused" if needed.
- Choose a Master SKU field (e.g., Shopify Variant SKU).
- Select Product & Listing Management option (e.g., "Create products & listings only").
- 4 Save and Complete: Click "Save and Complete" to finalize setup.
- 5 Run the Integration: Start with Run Sync manually.
After importing, manage your listings in Flxpoint:
Pausing New Listings
If "Set New Listings to Paused" is enabled, newly imported listings are set to "Paused" in Flxpoint, allowing review and source connection before syncing.
Unpausing Listings
To activate listings, go to Channel Listings, select paused listings, and click Actions → Edit → Unpause.
Product & Listing Management Options
- Create Products & Listings Only: Imports Shopify listings and links to existing listings by SKU; creates new listings if no match is found.
- Create New Products Only: Creates new products in Flxpoint without updating existing ones.
- Create and Update Products & Listings: Imports and links listings by SKU, overwriting existing Flxpoint data with Shopify data if a match is found, or creates new listings if no match exists.
The integration supports importing a wide range of fields from Shopify into Flxpoint.
Listing Parent Fields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| externalListingId | Flxpoint externalListingId | 123456789 | Identifies the parent listing | Supported |
| SKU (Handle) | Flxpoint SKU | product-handle | Unique identifier for the product | Supported |
| Title | Flxpoint Title | Blue T-Shirt | Product name | Supported |
| Description | Flxpoint Description | Comfortable cotton t-shirt | Product description | Supported |
| Manufacturer | Flxpoint Manufacturer | BrandX | Product manufacturer | Supported |
| Images | Flxpoint Images | image_url.jpg | Product images | Supported |
| customField (Product Metafields) | Flxpoint customField | color: blue | Additional product metadata | Supported |
| Attributes (Tags) | Flxpoint Attributes | tag: summer | Product attributes | Supported |
| Category1 (CustomCollection1) | Flxpoint Category1 | Apparel | Primary category | Supported |
| Category2 (CustomCollection2) | Flxpoint Category2 | T-Shirts | Secondary category | Supported |
| Category3 (CustomCollection3) | Flxpoint Category3 | Casual | Tertiary category | Supported |
Listing Variant Fields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| externalListingId | Flxpoint externalListingId | 987654321 | Identifies the variant | Supported |
| SKU | Flxpoint SKU | variant-sku-001 | Unique identifier for the variant | Supported |
| UPC (Barcode) | Flxpoint UPC | 012345678905 | Universal product code | Supported |
| Title | Flxpoint Title | Blue T-Shirt - Medium | Variant name | Supported |
| Price | Flxpoint Price | 29.99 | Variant price | Supported |
| MSRP (Compare at Price) | Flxpoint MSRP | 39.99 | Manufacturer’s suggested retail price | Supported |
| SalePrice | Flxpoint SalePrice | 24.99 | Discounted price | Supported |
| Quantity | Flxpoint Quantity | 100 | Available stock | Supported |
| customFields (Variant Metafields) | Flxpoint customFields | size: medium | Additional variant metadata | Supported |
| Options | Flxpoint Options | Medium, Blue | Variant options | Supported |
| Weight | Flxpoint Weight | 0.5 lbs | Variant weight (converts from grams if needed) | Supported |
| Weight Unit | Flxpoint Weight Unit | lbs | Unit of weight | Supported |
Supported Features and Limitations
- Custom Fields: Supported—Parent and variant metafields are imported as custom fields.
- Variations/Options: Supported—Imports variant options.
- Generic Pricing & Currency: Not supported—List price from the store is imported.
- Client Pricing & Currency: Not supported.
- Quantity: Supported—Imported as an aggregate value for all locations.
- Multiple Warehouses: Supported—Product data is saved for all locations, but location selection isn’t available.
- Weights & Dimensions: Supported—Weight in oz, lb, kg; dimensions are not set by default.
- Images: Supported—Images are imported via store-hosted URLs; multiple images are supported.
- Categories: Not supported—Category linking in Flxpoint is not available.
Troubleshoot issues with these steps:
- Missing SKU Errors: If errors like "SKU must be provided to create a variant" appear in the Recent Notifications log, ensure the Shopify Variant SKU field is populated.
- Connection Issues: Verify Shopify connection is active and credentials are valid.
- Master SKU Settings: Ensure the chosen Master SKU field (e.g., Shopify Variant SKU) contains data to avoid import failures.
- Recent Notifications: Check Shopify Channel Settings > Integrations > Import Listings for a breakdown of created/updated items and errors.
Diagnostic Tip: Missing SKU errors often result from unmapped or empty Shopify Variant SKU fields.
Key information:
- Date: As of 08:13 PM -04, May 29, 2025, this integration is operational.
- Required Fields: Shopify Variant SKU or Barcode must be mapped to Flxpoint’s Master SKU.
- Manual Execution: Scheduling is not supported; run the integration manually.
Pro Tip: Always map the Master SKU field to ensure accurate listing identification.
Conclusion
The Shopify Import Listings integration automates product imports into Flxpoint, ensuring your inventory reflects accurate Shopify data. Customize Master SKU, product management, and pausing options to fit your workflow, streamlining inventory management. Happy syncing!
Sync & Link Listings
Supported | Shopify - Sync & Link Listings
Introduction to Shopify Sync & Link Listings
Welcome to the Shopify Sync & Link Listings integration guide! This integration connects your Flxpoint inventory with your Shopify store, ensuring product details like price, quantity, and status are consistently updated. It streamlines inventory management for businesses of all sizes. Let’s get started!
The Shopify Sync & Link Listings integration enables you to:
- Seamlessly sync price, quantity, and variant attributes between Flxpoint and Shopify.
- Accurately link Flxpoint listings to Shopify products using identifiers like UPC or SKU.
- Control product visibility by hiding or delisting products on Shopify based on stock or status.
- Support both simple products and variants, such as products with multiple sizes or colors.
The integration follows these steps:
- 1 Connecting to Shopify: Establish a connection using API credentials or OAuth2 authentication to access your Shopify store.
- 2 Retrieving Product Data: Flxpoint pulls product data, including variants, from Shopify using API calls.
- 3 Linking Listings: Matches Flxpoint listings to Shopify products using identifiers like UPC or SKU, based on linking priority settings.
- 4 Mapping Data: Aligns Flxpoint data with Shopify fields using a mapping template.
- 5 Syncing Updates: Updates Shopify with the latest price, stock, and variant information from Flxpoint.
- 6 Managing Visibility: Hides or delists products on Shopify based on stock levels or status, such as marking them as "Out of Stock."
Pro Tip: Set clear linking priorities to ensure accurate matching between Flxpoint and Shopify listings.
Note: Hidden products remain active in Shopify admin unless unchecked for the "Online Store" channel.
Customize the integration with these settings:
- Connection: Select your Shopify store connection (e.g., "Shopify Connection API - Shopify App (OAuth2)").
- Location ID: Specify the Shopify inventory location ID to update inventory for that location.
- Linking Priority: Define matching criteria, such as Listing Variant SKU to Shopify Variant SKU.
- Scheduling: Run manually or schedule syncs (e.g., daily at 6 AM UTC).
- Mapping Template: Define how Flxpoint fields map to Shopify fields (see Mapping Template Details).
Note: Ensure the Location ID matches the intended Shopify inventory location to avoid syncing errors.
Follow these steps:
- 1 Add the Integration: Go to Channels > Shopify > Integrations, select "Sync Listings."
- 2 Connect to Shopify: Use existing Shopify credentials or set up a new connection via OAuth2 authentication.
-
3 Configure Settings:
- Specify the Location ID.
- Set Linking Priority (e.g., Listing Variant SKU to Shopify Variant SKU).
- Enable scheduling if desired.
- 4 Create Mapping Template: Configure field mappings (see Mapping Template Details).
- 5 Run the Integration: Start with Run Sync or schedule.
Control how products appear on Shopify:
Hiding Products
Hiding a variant sets it to "Out of Stock" on Shopify, preventing orders when stock is unavailable. Hidden products remain active in Shopify admin unless unchecked for the "Online Store" channel.
Unhiding Products
Unhiding makes hidden variants live again on Shopify for sales when stock is available.
Delisting Products
Delisting permanently removes a product from your Shopify channel listing. Run a sync/publish job to restore it.
Mapping templates control how Flxpoint data is synced to Shopify.
Interface Overview
- Screen labeled "Sync Listings" at the top; name your template (e.g., "Shopify Sync Listings 1").
- Buttons: Delete, Duplicate, Save Mapping.
- Columns: Flxpoint fields (left, e.g., Listing Variant Quantity), Shopify fields (right, e.g., Quantity).
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., Quantity to Quantity).
- Value: Set a static value (e.g., Price to "50").
- Rules: Apply conditional logic (e.g., hide if Quantity < 1, if available).
Quantity Mapping Requirement
The Quantity field must be mapped to ensure proper inventory syncing.
- Required Field: Quantity uniquely tracks inventory levels.
-
Error Scenario: Unmapped Quantity may cause:
Invalid request: Missing required field 'Quantity' for inventory sync
- Fix: Go to Channels > Shopify > Templates > Sync Listings > Field Mapping, map Listing Variant Quantity to Shopify Quantity, save, and re-run sync.
Recommendation: Always map Quantity and Price for reliable inventory and pricing updates.
Complete Field Mappings
Below are the fields you can map from Flxpoint to Shopify:
Shopify Product Fields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| Status | Flxpoint Status | Active | Sets product status (Active, Draft, Archived) | Optional (Don’t Map unless needed) |
Shopify Variant Fields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| Compare At Price | Listing Variant - MSRP | $50 | Shows crossed-out price higher than actual price | Supported |
| Cost | Listing Variant - Estimated Cost | $20 | Tracks product cost | Supported |
| Price | Listing Variant - List Price | $30 | Sets selling price | Supported |
| Quantity | Listing Variant - Quantity | 50 | Updates stock level | Required |
| Requires Shipping | Flxpoint Requires Shipping | True | Indicates if shipping is needed | Optional (Don’t Map unless needed) |
| Track Inventory | Flxpoint Track Inventory | True | Enables inventory tracking | Optional (Don’t Map unless needed) |
Troubleshoot issues with these steps:
- Connection Issues: Verify Shopify connection is active and credentials are valid.
- Linking Errors: Confirm identifiers (e.g., SKU, UPC) match between Flxpoint and Shopify.
- Mapping Issues: Ensure fields are mapped correctly (e.g., Quantity to Quantity).
- Product Status: If a product is in "Draft" in Shopify, Flxpoint shows it as hidden; set to "Active."
- GraphQL Inventory: If Track Inventory is "false" in Shopify, quantity won’t update; ensure it’s enabled.
Diagnostic Tip: Quantity sync failures often result from unmapped Quantity fields or disabled inventory tracking.
Key information:
- Date: As of 08:15 PM -04, May 29, 2025, this integration is operational.
- Required Fields: Quantity must be mapped; SKU or UPC recommended for linking.
- API Limits: Monitor Shopify API rate limits to avoid sync interruptions.
Pro Tip: Map Quantity and Price, and verify SKU/UPC for reliable syncing and linking.
Conclusion
The Shopify Sync & Link Listings integration automates inventory updates, ensuring your Flxpoint and Shopify data stay aligned. Customize mappings, linking priorities, and schedules to fit your workflow, streamlining inventory management. Happy syncing!
Publish Listings
Supported | Shopify - Publish Listings
Introduction to Shopify Publish Listings
Welcome to the Shopify Publish Listings integration guide! This integration enables you to publish Flxpoint listings to your Shopify store, creating or updating products and variants. It ensures accurate product data management directly from Flxpoint. Let’s get started!
The Shopify Publish Listings integration enables you to:
- Publish or update products and variants on Shopify using Flxpoint data.
- Support up to 100 variants per product with up to 3 options (e.g., size, color).
- Customize data mapping for fields, including metafields, categories, and tags.
- Automate publishing with scheduled jobs for consistent updates.
The integration follows these steps:
- 1 Connecting to Shopify: Establish a connection using API credentials or OAuth2 authentication to access your Shopify store.
- 2 Creating/Updating Products: A POST request to /admin/api/{version}/products.json creates or updates products at a specified inventory location.
- 3 Mapping Data: Aligns Flxpoint data with Shopify fields using a mapping template, including categories, metafields, and tags.
- 4 Handling Variants: Publishes variants with up to 3 options, positioning them based on option values (e.g., Color: White/Blue).
- 5 Publishing Attributes: Publishes listing attributes as Shopify tags and supports metafields for additional data.
- 6 Scheduling Publishing: Optionally automates publishing using UTC time zone scheduling.
Pro Tip: Enable scheduling to keep Shopify listings updated automatically without manual intervention.
Note: Ensure variant options do not exceed Shopify’s limit of 3 per product.
Customize the integration with these settings:
- Connection: Select your Shopify store connection (e.g., "Shopify Connection API - Shopify App (OAuth2)").
- Location ID: Specify the Shopify inventory location ID for publishing products.
- Additional Variant Images: Enable to upload variant-specific images to products with a parent image.
- Namespace: Define the namespace for metafields when configuring direct copy to Shopify.
- Truncate Title to 255: Trim product titles to 255 characters to meet Shopify’s limit.
- Auto-Create Smart Collection: Automatically create Smart Collections for mapped Product Types.
- Advanced Image Duplication Logic: Use cached MD5 checksums to prevent duplicate image uploads.
- Use Underscore in Meta Fields Name: Use underscores as separators in metafield names.
- Sort Variants by Option Position: Sort variants by option position for new parent products.
- Automate: Schedule automatic publishing in UTC time zone.
- Mapping Template: Define Flxpoint-to-Shopify field mappings, including rules for categories and metafields.
Note: Enable "Truncate Title to 255" to avoid publishing failures due to long titles.
Follow these steps:
- 1 Add the Integration: Go to Channels > Shopify > Integrations, select "Publish Listings."
- 2 Connect to Shopify: Use existing Shopify credentials or set up a new connection via OAuth2 authentication.
-
3 Configure Settings:
- Specify the Location ID.
- Enable options like "Truncate Title to 255," "Advanced Image Duplication Logic," and "Sort Variants by Option Position."
- Enable scheduling if desired.
- 4 Create Mapping Template: Configure field mappings, including categories and metafields (see Mapping Template Details).
- 5 Run the Integration: Start with Run Sync or schedule.
Mapping templates control how Flxpoint data is published to Shopify.
Interface Overview
- Screen labeled "Publish Listings" at the top; name your template (e.g., "Shopify Publish Listings 1").
- Buttons: Delete, Duplicate, Save Mapping.
- Columns: Flxpoint fields (left, e.g., Listing Parent Title), Shopify fields (right, e.g., Title).
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., Title to Title).
- Value: Set a static value (e.g., Tags to "Tag1,Tag2,Tag3").
- Rules: Apply conditional logic (e.g., set Category based on Category 1).
SKU Mapping Requirement
The SKU field must be mapped to ensure proper variant identification.
- Required Field: SKU uniquely identifies variants.
-
Error Scenario: Unmapped SKU may cause:
Invalid request: Missing required field 'SKU' for variant publishing
- Fix: Go to Channels > Shopify > Templates > Publish Listings > Field Mapping, map Listing Variant SKU to Shopify SKU, save, and re-run sync.
Recommendation: Always map SKU, Title, and Price for reliable product publishing.
Complete Field Mappings
Below are the fields you can map from Flxpoint to Shopify:
Shopify Product Fields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| Title | Listing Parent - Title | Blue T-Shirt | Sets product title | Required |
| Description | Listing Parent - Description | Comfortable cotton t-shirt | Sets product description | Supported |
| Tags | Listing Parent - Attribute | Tag1,Tag2,Tag3 | Adds comma-separated tags | Supported |
| Category | Listing Parent - Category 1 | gid://shopify/TaxonomyCategory/ap-1 | Sets product category | Supported |
Shopify Variant Fields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| SKU | Listing Variant - SKU | variant-sku-001 | Identifies the variant | Required |
| Price | Listing Variant - List Price | $30 | Sets selling price | Supported |
| Compare At Price | Listing Variant - MSRP | $50 | Shows crossed-out price | Supported |
| Weight | Listing Variant - Weight | 0.5 | Sets variant weight | Supported |
| Weight Unit | Listing Variant - Weight Unit | lb | Sets unit of weight | Supported |
Shopify Metafields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| Custom Fields | Listing Variant - Custom Field | color: blue | Adds metafield data (single_line_text) | Supported |
Mapping Categories
Use rules to map Flxpoint categories to Shopify’s Taxonomy Category IDs.
- Refer to Shopify’s Product Taxonomy for category IDs (e.g., "gid://shopify/TaxonomyCategory/ap-1" for "Live Animals").
- Example Rule: If Category 1 = "Live Animals," set Category to "gid://shopify/TaxonomyCategory/ap-1."
Be aware of these Shopify constraints:
- Product Options: Maximum of 3 options per product (e.g., Size, Color, Material).
- Attributes and Custom Field Titles: Limited to 30 characters.
- Image Size: Maximum 4472 x 4472 pixels, 20 MB file size.
- Product Limits: 1,000 products/day for regular Shopify accounts (Shopify Plus accounts exempt).
Troubleshoot issues with these steps:
- Title Length Errors: Enable "Truncate Title to 255" if titles exceed 255 characters.
- Variant Option Limits: Ensure no more than 3 options and 100 variants per product.
- Metafield Errors: Verify Namespace, Key, and Value; only single_line_text metafields supported.
- Image Upload Issues: Check images meet Shopify’s size limits; enable "Advanced Image Duplication Logic."
- Category Mapping Issues: Ensure category IDs match Shopify’s Taxonomy.
-
Product Does Not Exist Error: Unlink and re-link the product in Flxpoint if it was deleted in Shopify.
Error: Product does not exist
- Product Variant Does Not Exist: For recurring errors (e.g., "GraphQL Request Failed: Product variant does not exist" for SKU 2190-Case), contact Flxpoint support if unlinking/re-linking fails.
- Mismatched Titles and Variant Structures: Align Shopify product titles and variant groupings with Flxpoint to resolve publishing errors.
- Price/Quantity Sync Errors: Contact Flxpoint support for structural mismatches affecting price or quantity syncing.
Diagnostic Tip: Variant structure mismatches often cause publishing errors; ensure Flxpoint and Shopify align.
Key information:
- Date: As of 08:18 PM -04, May 29, 2025, this integration is operational.
- Required Fields: SKU and Title must be mapped.
- API Limits: Monitor Shopify API rate limits to avoid sync interruptions.
- Product Limits: 1,000 products/day for regular Shopify accounts.
Pro Tip: Map SKU, Title, and Price, and verify category IDs for reliable publishing.
Conclusion
The Shopify Publish Listings integration simplifies managing your Shopify store inventory from Flxpoint. With support for variants, metafields, and automated scheduling, it ensures accurate product data publishing while adhering to Shopify’s requirements. Happy publishing!
Order Operations
Get Orders
Supported | Shopify - Get Orders
Introduction to Shopify Get Orders
Welcome to the Shopify Get Orders integration guide! This integration retrieves new Shopify orders into Flxpoint and tags them in Shopify upon successful import, centralizing order management across multiple locations. Let’s get started!
The Shopify Get Orders integration enables you to:
- Import orders based on financial and fulfillment status for precise order retrieval.
- Support multi-location order management using FulfillmentOrder or Order.location_id.
- Import custom fields and digital items as configured in your mapping template.
- Acknowledge imported orders by tagging them in Shopify (e.g., “Received by Flxpoint”).
The integration follows these steps:
- 1 Connecting to Shopify: Establish a connection using OAuth2 authentication to access your Shopify store.
-
2 Fetching Order Data: A GET call to
/admin/api/{version}/orders.jsonretrieves orders with specified filters. - 3 Filtering Orders: Applies financial (e.g., Paid) and fulfillment (e.g., Unfulfilled) filters; excludes “Scheduled” and “On hold” orders.
- 4 Mapping Data: Maps Shopify order data to Flxpoint fields using a mapping template.
-
5 Determining Location: Uses Order.location_id or FulfillmentOrder’s
assigned_location_id(if enabled) for location handling. - 6 Tagging Orders: Optionally tags imported orders in Shopify (e.g., “Received by Flxpoint”).
Pro Tip: Enable “Upload Tag After Import” to track which orders have been imported into Flxpoint.
Note: Orders are imported once; subsequent Shopify changes are not updated in Flxpoint.
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 (required unless “Import Orders with No Location ID” is enabled).
- Financial Status: Filter by Any, Authorized, Pending, Paid, Partially Paid, Refunded, Voided, or Partially Refunded.
- Fulfillment Status: Filter by Unfulfilled, Partially Fulfilled, or Fulfilled.
- Get Orders Updated Within the Last X Days: Set the time frame for order retrieval (default: 14 days).
- Upload Tag After Import: Add a tag to imported orders in Shopify (e.g., “Received by Flxpoint”).
- PII Retention: Retain personally identifiable information indefinitely or for a set number of days.
- Import Orders with No Location ID: Enable to include orders without a location ID.
-
Read Location From Fulfillment Order: When enabled, fetches each order’s FulfillmentOrder via a separate API call and uses
assigned_location_idif exactly one exists. - Mapping Template: Define how Shopify fields map to Flxpoint fields.
Note: Configure Shopify’s location priority settings before syncing to ensure accurate multi-location handling.
Follow these steps:
- 1 Add the Integration: Go to Channels > Shopify > Integrations, select “Get Orders.”
- 2 Connect to Shopify: Select an existing Shopify OAuth connection or set up a new one.
-
3 Configure Settings:
- Specify Location ID (or enable “Import Orders with No Location ID”).
- Set Financial and Fulfillment Status filters.
- Define the time frame (e.g., last 14 days).
- Enable “Read Location From Fulfillment Order” if needed.
- Set “Upload Tag After Import” and PII Retention options.
- 4 Create Mapping Template: Configure field mappings for Billing/Shipping Address, Order, and Line Items (see Mapping Template Details).
- 5 Run the Integration: Start with Run Sync or schedule automatic syncs.
Mapping templates control how Shopify order data is imported into Flxpoint.
Interface Overview
- Screen labeled “Get Orders” at the top; name your template (e.g., “Shopify Get Orders 1”).
- Buttons: Delete, Duplicate, Save Mapping.
- Sections: Billing Address, Shipping Address, Order, Line Items.
- Columns: Shopify fields (left, e.g., Order Number), Flxpoint fields (right, e.g., Order ID).
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., Order Number to Order ID).
- Value: Set a static value (e.g., Order Status to “Imported”).
- Rules: Apply conditional logic (e.g., import only if Financial Status is “Paid”).
SKU Mapping Requirement
The Line Item SKU field must be mapped to ensure proper order item identification.
- Required Field: SKU uniquely identifies order items.
-
Error Scenario: Unmapped SKU results in items imported as “Non-Managed”:
Warning: SKU must be provided for line item import
- Fix: Go to Channels > Shopify > Templates > Get Orders > Field Mapping, map Shopify Line Item SKU to Flxpoint SKU, save, and re-run sync.
Recommendation: Always map SKU, Order Number, and Quantity for reliable order importing.
Complete Field Mappings
Below are example fields you can map from Shopify to Flxpoint:
Order Fields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| Order Number | Flxpoint Order ID | #1001 | Identifies the order | Required |
| Created At | Flxpoint Order Date | 2025-05-29T10:00:00Z | Sets order creation date | Supported |
| Total Price | Flxpoint Total Amount | $99.99 | Sets order total | Supported |
Line Item Fields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| SKU | Flxpoint SKU | item-sku-001 | Identifies the item | Required |
| Quantity | Flxpoint Quantity | 2 | Sets item quantity | Supported |
| Price | Flxpoint Unit Price | $49.99 | Sets item price | Supported |
Billing/Shipping Address Fields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| First Name | Flxpoint First Name | John | Sets customer first name | Supported |
| Address1 | Flxpoint Address Line 1 | 123 Main St | Sets address line | Supported |
Flxpoint supports multi-location order management:
- Uses FulfillmentOrder’s
assigned_location_idor Order.location_id for precise location handling. - Configure Shopify’s location priority settings before syncing to ensure accurate order assignment. Learn more.
- Enable “Read Location From Fulfillment Order” to fetch
assigned_location_idvia a separate API call, ensuring only orders with a single FulfillmentOrder are imported.
Pro Tip: Verify Shopify location priorities to avoid order assignment mismatches.
Be aware of these constraints:
- Single Import: Orders are imported once; subsequent Shopify changes are not updated in Flxpoint.
- SKU Requirement: Orders without SKUs are imported as “Non-Managed.”
- Status Exclusions: “Scheduled” and “On hold” orders are not supported.
Troubleshoot issues with these steps:
- Orders Not Importing: Verify Financial and Fulfillment Status filters match desired orders.
- Location ID Issues: Ensure the Location ID is correct or enable “Import Orders with No Location ID.”
- Mapping Errors: Check that required fields (e.g., SKU, Order Number) are mapped in the template.
-
Non-Managed Items: If items import as “Non-Managed,” ensure Shopify Line Item SKU is populated and mapped.
Warning: Line item imported as Non-Managed due to missing SKU
- Fulfillment Order Errors: If “Read Location From Fulfillment Order” is enabled, ensure orders have exactly one FulfillmentOrder.
Diagnostic Tip: Missing orders often result from restrictive status filters or unmapped SKUs.
Key information:
- Date: As of 08:21 PM -04, May 29, 2025, this integration is operational.
- Required Fields: SKU and Order Number must be mapped.
- API Limits: Monitor Shopify API rate limits to avoid sync interruptions.
Pro Tip: Map SKU and Order Number, and verify status filters for reliable order importing.
Conclusion
The Shopify Get Orders integration centralizes Shopify orders in Flxpoint, offering flexible location handling and advanced mapping for accurate fulfillment workflows. Customize filters, mappings, and tags to fit your needs, streamlining order management. Happy syncing!
Sync Orders
Supported | Shopify - Sync Orders
Introduction to Shopify Sync Orders
Welcome to the Shopify Sync Orders integration guide! This integration enables Flxpoint to send shipment updates to Shopify, syncing fulfillment details like tracking numbers and carrier information, and optionally updating order statuses to "Closed" for orders with partial or no fulfillment data, including In-Store orders. It ensures accurate tracking and order status updates across all sales channels. Let’s get started!
The Shopify Sync Orders integration enables you to:
- Update Shopify with shipment details like tracking numbers, URLs, and carrier information.
- Sync a "Closed" status for orders with partial or no fulfillment data, including auto-closed In-Store orders, archiving future orders from Shopify.
- Support multi-location inventory by associating shipments with the correct Shopify Location ID.
- Handle partial shipments, updating Shopify with "Partially Shipped" or "Shipped" statuses.
- Notify customers of shipment updates via Shopify, configurable in the mapping template.
The integration follows these steps:
- 1 Connecting to Shopify: Establish a connection using OAuth2 authentication to access your Shopify store.
-
2 Sending Fulfillment Data: A POST request to
/admin/api/{version}/fulfillments.jsonsends fulfillment details for a specified order_id. - 3 Handling Multi-Location: Syncs shipments for items from the same location; retries failed shipments for other locations in the next sync job.
- 4 Mapping Data: Aligns Flxpoint shipment data with Shopify fulfillment fields using a mapping template.
- 5 Updating Order Status: Updates Shopify with "Partially Shipped" or "Shipped" statuses, and optionally "Closed" for orders with partial/no fulfillment data, including In-Store orders.
- 6 Notifying Customers: Optionally sends shipment update notifications to customers, configurable via the mapping template.
Pro Tip: Enable "Sync 'Closed' Order Status" for In-Store orders to reflect their auto-closed status in Shopify.
Note: Ensure the Location ID matches the fulfillment location to avoid sync errors.
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 syncing fulfillments (required).
- Sync "Closed" Order Status: Enable to send a "Closed" status for orders with partial/no fulfillment data, including auto-closed In-Store orders.
- Shipping Mappings: Map Shopify shipping rates (e.g., Free, Expedited) to Flxpoint shipping policies (e.g., Ground, Two Day Shipping). For In-Store orders, map Channel Shipping Text (e.g., “In-Store”) to align with In-Store Order Workflow rules.
- Mapping Template: Define how Flxpoint shipment fields map to Shopify fulfillment fields.
Note: Accurate shipping mappings are critical for In-Store orders to ensure proper fulfillment designation.
Follow these steps:
- 1 Add the Integration: Go to Channels > Shopify > Integrations, select “Sync Orders.”
- 2 Connect to Shopify: Select an existing Shopify OAuth connection or set up a new one.
-
3 Configure Settings:
- Specify the Location ID.
- Enable “Sync 'Closed' Order Status” if needed, especially for In-Store orders.
- Configure shipping mappings (e.g., Shopify “Expedited” to Flxpoint “Two Day Shipping”; “In-Store” for In-Store orders).
- 4 Create Mapping Template: Configure field mappings for shipment data (see Mapping Template Details).
- 5 Run the Integration: Start with Run Sync to update Shopify manually.
Shipping mappings align Shopify shipping rates with Flxpoint shipping policies:
Configure Shipping Rates in Shopify
In Shopify, navigate to Settings → Shipping and Delivery → General Shipping Rates to manage rates. Example domestic rates:
- Expedited: $9.90 for 5lb–10lb.
- Free: Free for 0lb–1lb.
- Standard: $3.95 for $0.00–$30.00.
Map Shopify Rates to Flxpoint Policies
In Flxpoint’s “Shipping Mappings” section, map Shopify rates to Flxpoint policies:
- Free → Ground: Maps Shopify’s “Free” rate to Flxpoint’s “Ground” policy.
- Expedited → Expedited: Maps Shopify’s “Expedited” rate to Flxpoint’s “Expedited” policy.
- Standard → Two Day Shipping: Maps Shopify’s “Standard” rate to Flxpoint’s “Two Day Shipping” policy.
In-Store Order Shipping Text
For In-Store orders, map the Channel Shipping Text (e.g., “In-Store” or “POS”) in Flxpoint to match Shopify’s designation. Ensure this aligns with your In-Store Order Workflow rules for proper fulfillment.
Pro Tip: Verify Channel Shipping Text for In-Store orders to ensure accurate order identification.
Mapping templates control how Flxpoint shipment data is synced to Shopify.
Interface Overview
- Screen labeled “Sync Orders” at the top; name your template (e.g., “Shopify Sync Orders 1”).
- Buttons: Delete, Duplicate, Save Mapping.
- Columns: Flxpoint fields (left, e.g., Shipment Tracking Number), Shopify fields (right, e.g., Tracking Number).
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., Tracking Number to Tracking Number).
- Value: Set a static value (e.g., Notify Customer to “True”).
- Rules: Apply conditional logic (e.g., notify customer only for specific carriers).
Tracking Number Mapping Requirement
The Tracking Number field must be mapped to ensure proper fulfillment syncing.
- Required Field: Tracking Number identifies shipments.
-
Error Scenario: Unmapped Tracking Number may cause:
Invalid request: Missing required field 'Tracking Number' for fulfillment sync
- Fix: Go to Channels > Shopify > Templates > Sync Orders > Field Mapping, map Shipment Tracking Number to Shopify Tracking Number, save, and re-run sync.
Recommendation: Always map Tracking Number, Tracking Company, and Notify Customer for reliable fulfillment updates.
Complete Field Mappings
Below are the fields you can map from Flxpoint to Shopify:
Shopify Fulfillment Fields
| Shopify Field | Maps To | Example | Purpose | Status |
|---|---|---|---|---|
| Location ID | Flxpoint Location ID | 123456789 | Specifies fulfillment location | Optional (Don’t Map; set by integration) |
| Notify Customer | Fixed Value | True | Notifies customer of shipment | Supported |
| Tracking Company | Shipment - Carrier | UPS | Sets carrier name | Supported |
| Tracking Number | Shipment - Tracking Number | 1Z9999W999999999 | Sets tracking number | Required |
| Tracking URL | Shipment - Tracking URL | https://ups.com/track | Sets tracking URL | Supported |
Flxpoint leverages Shopify’s multi-location inventory for accurate fulfillment:
- Location ID Requirement: Specify a Location ID in Flxpoint to sync fulfillments. Refer to Shopify’s guide on managing locations.
- Multi-Location Shipments: Syncs shipments for items from the same location; retries failed shipments for other locations in the next sync job. Applies to both online and In-Store orders.
Pro Tip: Verify Location IDs in Shopify to ensure shipments sync to the correct location.
Be aware of these constraints:
- Manual Order Item Limitations: Flxpoint does not support manual order item limitations for syncing shipments.
- Sync "Closed" Limitation: Affects only future orders; existing orders are not updated. Applies to In-Store orders for auto-closed status syncing.
Troubleshoot issues with these steps:
-
Shipment Not Syncing: If a product was deleted in Shopify (e.g., ordered Tuesday, deleted Wednesday, shipped Thursday), Shopify throws an error:
Error: Product cannot be locatedResolve by unlinking/re-linking the product in Flxpoint, as detailed in the Publish Listings section.
- Multi-Location Errors: Verify the Location ID matches the fulfillment location. For In-Store orders, ensure the fulfillment source aligns with In-Store Order Workflow settings.
- Customer Not Notified: Ensure “Notify Customer” is mapped to “True” in the mapping template.
- Additional Sync Errors: For errors like “Product variant does not exist” or price/quantity sync issues, refer to the Publish Listings section to resolve product linking mismatches.
Diagnostic Tip: Shipment sync failures often stem from deleted products or incorrect Location IDs.
Key information:
- Date: As of 08:26 PM -04, May 29, 2025, this integration is operational.
- Required Fields: Tracking Number must be mapped; Location ID is required.
- API Limits: Monitor Shopify API rate limits to avoid sync interruptions.
Pro Tip: Map Tracking Number and Tracking Company, and verify Location ID for reliable syncing.
Conclusion
The Shopify Sync Orders integration streamlines fulfillment updates, ensuring Shopify reflects accurate shipment details and order statuses from Flxpoint. With support for multi-location inventory, In-Store orders, and customizable mappings, it enhances order management across all sales channels. Happy syncing!