Shopify as a Channel

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

Step 1: Log in to your Flxpoint account and go to Sales Channels.
Step 2: Click "+" to Create Channel.
Step 3: In the Channel Setup screen:
Search for Shopify and select it.
Enter a Channel Name (e.g., "Shopify Store").
Click Save & Next.
In Connect to Your Shopify Store:
Recommended: Choose API - Shopify App (OAuth2) and click Initiate OAuth2 Flow to authorize Flxpoint securely.
Or select API - Bearer Token or API - Basic Auth for manual credential entry in the next step.
Step 4: Get Shopify API credentials (for Bearer Token or Basic Auth):
Log in to your Shopify Admin at https://www.shopify.com/login.
Go to Apps > Develop apps for your store (enable custom app development if needed).
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’s URL (e.g., https://{your-shop-name}.myshopify.com).
Step 5: Enter Shopify connection details (for Bearer Token or Basic Auth):
Set a Connection Name (e.g., "Shopify Connection #1").
For API - Bearer Token, paste the Admin API access token into the Token field.
For API - Basic Auth, enter the API Key and API Secret Key.
Input your Store URL (e.g., https://{your-shop-name}.myshopify.com).
Click Test Connection, then Save & Next if successful.
API Rate Limits: Shopify enforces limits (details at Shopify API Rate Limits):
REST API: 2 req/sec (standard), 4 req/sec (Shopify Plus).
GraphQL: 50 points/sec (standard plans).
OAuth2 is exempt; optimize with Flxpoint sync schedules.
Troubleshooting: Verify credentials and permissions if the connection fails.
Step 6: Configure integration settings:
For Import Listings, set new listings to Paused and configure Master SKU.
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.
For Get Orders, select statuses (e.g., Open) and time range.
Location ID Note: Orders with or without a Location ID are saved unless disabled in Advance Config.
Click Confirm to proceed.
Step 7: In Channel Created:
Review settings and enable processes (e.g., import listings).
To integrate with TikTok Shop (optional):
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, enabling you to publish listings from your Shopify channel to TikTok Shop.
Verify the integration by checking that listings can be published to TikTok Shop via the Shopify channel in Flxpoint.
Click Confirm & Finish.
Final Step: Your channel is ready! In Sales Channels:
Start Import Listings to sync products.
Start Get Orders to manage orders.
Check Sync and Link Listings and Publish Listings.

 

 

Listing Operations

Import Listings

Supported | Shopify - Import Listings

1. Introduction to Shopify Import Listings
The Shopify Import Listings integration allows you to bring product listings from your Shopify store into Flxpoint, creating or updating listings in Flxpoint based on Shopify data. This integration is ideal for businesses looking to centralize their inventory management by importing Shopify products and variants into Flxpoint for further syncing or sourcing.

2. Why Use This Integration?
This integration provides key benefits:
- Centralize Inventory: Import Shopify listings into Flxpoint to manage inventory across multiple channels.
- Define Master SKUs: Set a unique identifier (Master SKU) in Flxpoint to connect Shopify listings with fulfillment sources.
- Control Import Behavior: Choose how listings are created or updated in Flxpoint, with options to pause new listings for review.
- Support Variants: Imports both parent products and variants, including fields like price, quantity, and metafields.

3. How the Integration Works
The integration follows these steps to import listings:
1. Fetch Products: Flxpoint retrieves product data, including variants, from Shopify using a GET call to the endpoint /admin/api/{version}/products.json.
2. Define Master SKU: Maps a Shopify field (e.g., Shopify Variant Barcode or SKU) to Flxpoint’s Master SKU for unique identification.
3. Import Listings: Creates or updates listings in Flxpoint based on Shopify data, following the selected Product & Listing Management settings.
4. Handle Variants: Imports variant-specific fields like price, quantity, and metafields into Flxpoint.
5. Pause New Listings (Optional): Sets newly imported listings to a "Paused" status to allow review before syncing with sources.

4. Configuration Options
Customize the integration to suit your workflow:
- 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, giving you time to link them to sources before syncing.
- Set Your Master SKU: Choose a Shopify field (e.g., Shopify Variant Barcode or SKU) to populate Flxpoint’s Master SKU.
- Product & Listing Management: Select how listings are imported: "Create products & listings only," "Create new products only," or "Create and update products & listings."

5. Step-by-Step Setup Instructions
Follow these steps to set up the integration:
1. Add the Integration: In Flxpoint, go to the "Integrations" section, select "Shopify" as the type, and choose "Import Listings."
2. Connect to Shopify: Select an existing Shopify connection or set up a new one using your Shopify credentials.
3. Configure Settings: Enable "Set New Listings to Paused" if needed, choose a Master SKU field (e.g., Shopify Variant SKU), and select your Product & Listing Management option (e.g., "Create products & listings only").
4. Save and Complete: Click "Save and Complete" to finalize the setup.
5. Run the Integration: Manually run the integration to import listings, as scheduling is not supported for Import Listings.

6. Managing Imported Listings
After importing, manage your listings in Flxpoint:
6.1 Pausing New Listings
If "Set New Listings to Paused" is enabled, newly imported listings are set to "Paused" in Flxpoint. This allows you to review and connect them to sources before syncing price and quantity data.
6.2 Unpausing Listings
To make listings active, go to the Channel Listings section in Flxpoint, select the paused listings, and click Actions → Edit → Unpause.
6.3 Product & Listing Management Options
- Create Products & Listings Only: Imports Shopify listings into Flxpoint and links them 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.

7. Fields That Can Be Imported
The integration supports importing a wide range of fields from Shopify into Flxpoint.
7.1 Listing Parent Fields
- externalListingId
- SKU (e.g., Handle)
- Title
- Description
- Manufacturer
- Images
- customField (e.g., Product Metafields)
- Attributes (e.g., Convert Tags to Attributes)
- Category1 (e.g., CustomCollection1)
- Category2 (e.g., CustomCollection2)
- Category3 (e.g., CustomCollection3)
7.2 Listing Variant Fields
- externalListingId
- SKU
- UPC (e.g., Barcode)
- Title
- Price
- MSRP (e.g., Compare at Price)
- SalePrice
- Quantity
- customFields (e.g., Variant Metafields)
- Options
- Weight (default in lbs; converts from grams if listed as such in Shopify)
- Weight Unit
7.3 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.

8. Troubleshooting Common Issues
Resolve common 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 in Shopify.
- Check Connection: Verify your Shopify connection is active and credentials are valid.
- Review Master SKU Settings: Ensure the chosen Master SKU field (e.g., Shopify Variant SKU) contains data in Shopify to avoid import failures.
- Monitor Recent Notifications: Check the Recent Notifications log (Shopify Channel Settings → Integrations → Import Listings) for a breakdown of created/updated items and errors.

9. Conclusion
The Shopify Import Listings integration simplifies inventory management by bringing your Shopify products into Flxpoint. With flexible settings for Master SKU, product management, and pausing new listings, it ensures your data is accurately imported and ready for further syncing or sourcing.
 
 

Sync & Link Listings

Supported | Shopify - Sync & Link Listings

1. Introduction to Shopify Sync & Link Listings
The Shopify Sync & Link Listings integration connects your Flxpoint inventory with your Shopify store, ensuring product details like price, quantity, and status are consistently updated. Designed for businesses of all sizes, this integration streamlines inventory management by automating data syncing and linking processes between Flxpoint and Shopify.

2. Why Use This Integration?
This integration offers key benefits:
- Seamless Data Syncing: Updates price, quantity, and variant attributes between Flxpoint and Shopify.
- Accurate Linking: Matches Flxpoint listings to Shopify products using identifiers like UPC or SKU.
- Visibility Control: Hides or delists products on Shopify when they’re out of stock or hidden in Flxpoint.
- Variant Support: Syncs both simple products and variants, such as a product with multiple sizes or colors.

3. How the Integration Works
The integration operates through these steps:
1. Retrieve Products: Flxpoint pulls product data, including variants, from your Shopify store.
2. Link Listings: Matches Flxpoint listings to Shopify products using identifiers like UPC or SKU, based on your linking priority settings.
3. Map Data: Aligns Flxpoint data with Shopify fields using a mapping template.
4. Sync Updates: Updates Shopify with the latest price, stock, and variant info from Flxpoint.
5. Manage Visibility: Hides or delists products on Shopify based on stock levels or status, such as marking them as "Out of Stock."

4. Configuration Options
Tailor the integration to your needs:
- Connection: Select your Shopify store connection (e.g., "Shopify Connection API - Shopify App (OAuth2)").
- Location ID: Specify the inventory location ID in Shopify to update inventory for the selected location.
- Linking Priority: Define how to match listings, such as using Listing Variant SKU to Shopify Variant SKU.
- Scheduling: Run the sync manually or schedule it (e.g., daily), using UTC time zone by default.
- Mapping Template: Define how Flxpoint data maps to Shopify fields (details below).

5. Step-by-Step Setup Instructions
Follow these steps to set up the integration:
1. Add the Integration: In Flxpoint, go to the "Integrations" section, select "Shopify" as the type, and choose "Sync Listings."
2. Connect to Shopify: Select an existing Shopify connection or set up a new one using your Shopify credentials.
3. Configure Settings: Specify the Location ID, set the Linking Priority (e.g., Listing Variant SKU to Shopify Variant SKU), and enable scheduling if desired.
4. Create a Mapping Template: Define how Flxpoint fields map to Shopify fields (see below).
5. Run the Integration: Click "Run Integration" to start manually, or let it run on your schedule.

6. Managing Product Visibility
Control how products appear on Shopify:
6.1 Hiding Products
Hiding a variant sets it to "Out of Stock" on Shopify, preventing orders when stock is unavailable. Note: Hidden products still appear active in Shopify admin unless unchecked for the "Online Store" channel.
6.2 Unhiding Products
Unhiding applies to variants already in hidden status, making them live again on Shopify for sales when stock is available.
6.3 Delisting Products
Delisting permanently removes a product from your Shopify channel listing. You’ll need to run a sync/publish job to bring it back.

7. Mapping Template: Connecting Flxpoint to Shopify
A mapping template ensures Flxpoint data transfers correctly to Shopify, such as mapping "Quantity" in Flxpoint to "Quantity" in Shopify.
7.1 Interface Overview
- Top Section: Labeled "Mapping Template," such as "Sync Listings 1."
- Buttons: Delete to remove the template, Duplicate to copy it, and Save to save changes.
- Mapping Sections:
- From Value: Flxpoint fields, like Listing Variant fields (e.g., Quantity, List Price).
- To Shopify Field: Shopify fields, like Quantity, Price, or Compare At Price.
7.2 Mapping Options
For each field, choose from:
- Don’t Map: Skip the field—no data is sent to Shopify.
- Set To Empty: Clear the field in Shopify, removing existing data.
- Field: Map a Flxpoint field to a Shopify field, like mapping "Quantity" to "Quantity."
- Value: Set a fixed value, such as setting Price to "50" for all products.
- Rules: Apply conditional logic, like hiding a product if Quantity is less than 1 (not always available).
7.3 Available Source Fields in Flxpoint
Flxpoint fields under "Listing Variant" include:
- Custom Aggregate Field (Key/Value)
- Estimated Cost (Number)
- Estimated Dropship Fee (Number)
- Estimated Shipping Cost (Number)
- List Price (Number)
- MAP (Minimum Advertised Price, Number)
- MSRP (Manufacturer’s Suggested Retail Price, Number)
- Quantity (Number)
7.4 Shopify Fields and Suggested Mappings
The mapping template includes sections for Shopify fields:
7.4.1 Shopify Product Fields
- Status: Product status (e.g., Active, Draft, Archived).
- Suggested Mapping: Set to "Don’t Map" unless you need to update status across all variants.
7.4.2 Shopify Variant Fields
- Compare At Price: Shows a crossed-out price higher than the actual price.
- Suggested Mapping: Map to "Listing Variant - MSRP."
- Example: If MSRP is $50 in Flxpoint, Compare At Price updates to $50 in Shopify.
- Cost: Product cost.
- Suggested Mapping: Map to "Listing Variant - Estimated Cost."
- Price: Product selling price.
- Suggested Mapping: Map to "Listing Variant - List Price."
- Example: If List Price is $30 in Flxpoint, Price updates to $30 in Shopify.
- Quantity: Product stock level.
- Suggested Mapping: Map to "Listing Variant - Quantity."
- Example: A product with 50 units in Flxpoint updates the Quantity to 50 in Shopify.
- Requires Shipping: Indicates if the product needs shipping.
- Suggested Mapping: Set to "Don’t Map" unless specific requirements apply.
- Track Inventory: Enables inventory tracking in Shopify.
- Suggested Mapping: Set to "Don’t Map" unless you want to toggle this setting. Quantity updates only occur if Track Inventory is enabled.

8. Troubleshooting Common Issues
Address common issues with these steps:
- Check Connection: Ensure your Shopify connection is active and credentials are valid.
- Verify Linking Priority: Confirm identifiers (e.g., SKU) match between Flxpoint and Shopify.
- Review Mapping Template: Ensure fields are mapped correctly, like Quantity to Quantity.
- Check Product Status: If a product is in "Draft," Flxpoint will show it as hidden; change it to "Active" in Shopify.
- GraphQL Inventory: If inventory tracking is set to "false," quantity won’t update in Shopify—ensure it’s enabled.

9. Conclusion
The Shopify Sync & Link Listings integration ensures your Flxpoint and Shopify data stay aligned, simplifying inventory management. It keeps prices, stock levels, and visibility settings accurate, with a flexible mapping template to meet your business needs.
 
 

Publish Listings

Supported | Shopify - Publish Listings

1. Introduction to Shopify Publish Listings
The Shopify Publish Listings integration enables you to publish Flxpoint listings to your Shopify store, creating or updating products and variants. This integration is designed for businesses looking to manage their Shopify store inventory directly from Flxpoint, ensuring product data like price, quantity, and attributes are accurately reflected on Shopify.

2. Why Use This Integration?
This integration offers key benefits:
- Publish Listings: Creates or updates products and variants on Shopify using Flxpoint data.
- Support Variants: Publishes up to 100 variants per product with up to 3 options (e.g., size, color).
- Customize Data: Maps Flxpoint fields to Shopify fields, including metafields, categories, and tags.
- Automate Publishing: Schedule publishing jobs to run automatically, ensuring consistent updates.

3. How the Integration Works
The integration follows these steps to publish listings:
1. Create or Update Products: Flxpoint uses a POST request to the Shopify endpoint /admin/api/{version}/products.json to create or update products at a specified inventory location.
2. Map Data: Aligns Flxpoint data with Shopify fields using a mapping template, including categories, metafields, and tags.
3. Handle Variants: Publishes variants with up to 3 options, positioning them based on option values (e.g., Color: White/Blue, Size: Newborn).
4. Publish Attributes: Publishes listing attributes as tags on Shopify and supports metafields for additional data.
5. Schedule Publishing: Optionally automate the publishing process using UTC time zone scheduling.

4. Configuration Options
Customize the integration to fit your needs:
- Connection: Select your Shopify store connection (e.g., "Shopify Connection API - Shopify App (OAuth2)").
- Location ID: Specify the inventory location ID in Shopify 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: Automatically trim product titles to 255 characters if they exceed Shopify’s limit; otherwise, the product fails to publish.
- Auto-Create Smart Collection: Enable to automatically create Smart Collections for Product Types mapped in the template.
- Advanced Image Duplication Logic: Enable to use cached MD5 checksums to prevent duplicate image uploads to Shopify.
- Use Underscore in Meta Fields Name: Enable to use underscores (_) as separators in metafield names.
- Sort Variants by Option Position: Enable to sort variants by option position when creating a new parent product.
- Automate: Enable scheduling to run the integration automatically in UTC time zone.
- Mapping Template: Define how Flxpoint fields map to Shopify fields, including rules for categories and metafields (details below).

5. Step-by-Step Setup Instructions
Follow these steps to set up the integration:
1. Add the Integration: In Flxpoint, go to the "Integrations" section, select "Shopify" as the type, and choose "Publish Listings."
2. Connect to Shopify: Select an existing Shopify connection or set up a new one using your Shopify credentials.
3. Configure Settings: Specify the Location ID, enable options like "Truncate Title to 255," "Advanced Image Duplication Logic," and "Sort Variants by Option Position" as needed, and enable scheduling if desired.
4. Create a Mapping Template: Define how Flxpoint fields map to Shopify fields, including categories and metafields (see below).
5. Run the Integration: Click "Run Integration" to publish listings manually, or let it run on your schedule if automation is enabled.

6. Mapping Template: Publishing Flxpoint Data to Shopify
A mapping template determines how Flxpoint data transfers to Shopify, ensuring fields like "Title" in Flxpoint update the correct Shopify field.
6.1 Interface Overview
- Top Section: Labeled "Mapping Template," like "Publish Listings 1."
- Buttons: Delete to remove the template, Duplicate to copy it, and Save to save changes.
- Mapping Sections:
- From Value: Flxpoint fields, like Listing Parent or Listing Variant fields (e.g., Title, Quantity).
- To Shopify Field: Shopify fields, like Title, SKU, or Metafields.
6.2 Mapping Options
For each field, choose from:
- Don’t Map: Skip the field—no data is sent to Shopify.
- Set To Empty: Clear the field in Shopify, removing existing data.
- Field: Map a Flxpoint field to a Shopify field, like mapping "Title" to "Title."
- Value: Set a fixed value, such as setting Tags to "Tag1,Tag2,Tag3."
- Rules: Apply conditional logic, like setting a category based on Flxpoint’s Category 1 field.
6.3 Available Source Fields in Flxpoint
Flxpoint fields include:
- Listing Parent: Title, Description, Image, Category 1, Category 2, Category 3, Custom Field, Attribute.
- Listing Variant: SKU, UPC, Title, List Price, MSRP, MAP, Quantity, Weight, Custom Field, Option.
6.4 Shopify Fields and Suggested Mappings
6.4.1 Shopify Product Fields
- Title: Product title.
- Suggested Mapping: Map to "Listing Parent - Title."
- Example: A product title in Flxpoint like "Blue T-Shirt" updates the Title to "Blue T-Shirt" in Shopify.
- Description: Product description.
- Suggested Mapping: Map to "Listing Parent - Description."
- Tags: Comma-separated tags.
- Suggested Mapping: Map to "Listing Parent - Attribute" or set a fixed value like "Tag1,Tag2,Tag3."
- Category: Shopify product category.
- Suggested Mapping: Use rules to map "Listing Parent - Category 1" to a Shopify Taxonomy Category ID (e.g., "gid://shopify/TaxonomyCategory/ap-1" for "Live Animals").
6.4.2 Shopify Variant Fields
- SKU: Variant SKU.
- Suggested Mapping: Map to "Listing Variant - SKU."
- Price: Variant selling price.
- Suggested Mapping: Map to "Listing Variant - List Price."
- Compare At Price: Crossed-out price for comparison.
- Suggested Mapping: Map to "Listing Variant - MSRP."
- Weight: Variant weight.
- Suggested Mapping: Map to "Listing Variant - Weight."
- Weight Unit: Unit of weight (e.g., lb, kg).
- Suggested Mapping: Map to "Listing Variant - Weight Unit (Abbreviated)."
6.4.3 Shopify Metafields
- Custom Fields: Supports mapping to metafields (single_line_text only).
- Suggested Mapping: Map to "Listing Variant - Custom Field."
6.5 Mapping Categories
If you have multiple internal categories, consider creating mapping sets or rules to automatically translate them into the corresponding global IDs from Shopify’s Taxonomy.
- Refer to Shopify’s Product Taxonomy documentation to find category IDs (e.g., "gid://shopify/TaxonomyCategory/ap-1" for "Live Animals").
- Use rules in the mapping template to set the Category field based on Flxpoint’s Category 1 (e.g., if Category 1 = "Live Animals," set Category to "gid://shopify/TaxonomyCategory/ap-1").

7. Limitations
Be aware of Shopify’s constraints:
- Product Options: Shopify allows a product to have at most 3 options (e.g., Size, Color, Material).
- Attributes and Custom Field Titles: Must be at most 30 characters long.
- Image Size: Maximum image size is 4472 x 4472 pixels with a file size of 20 MB or less.
- Product Limits: Regular Shopify accounts allow the creation of 1,000 products/day (this does not apply to Shopify Plus accounts).

8. Troubleshooting Common Issues
Address common issues with these steps:
- Title Length Errors: If a product fails to publish due to a title exceeding 255 characters, enable "Truncate Title to 255" in the settings.
- Variant Option Limits: Ensure products have no more than 3 options and 100 variants, as Shopify does not support more.
- Metafield Errors: Verify the Namespace, Key, and Value for metafields are correct; only single_line_text metafields are supported.
- Image Upload Issues: Check that images are within Shopify’s size limits (4472 x 4472 pixels, 20 MB); enable "Advanced Image Duplication Logic" to prevent duplicates.
- Category Mapping Issues: Ensure category IDs match Shopify’s Taxonomy; refer to Shopify’s documentation for valid IDs.
- Product Does Not Exist Error: If publishing fails with an error like "Product does not exist," the product may have been deleted in Shopify but is still linked in Flxpoint. To resolve, unlink the product in Flxpoint and then re-link it to the correct Shopify product. This ensures the product link is updated and publishing can proceed.
- Product Variant Does Not Exist (Recurring Error): If you see a recurring "GraphQL Request Failed: Product variant does not exist" error (e.g., for SKU 2190-Case), even after unlinking and re-linking, there may be a deeper mismatch. This can occur despite the SKU existing in Shopify. Contact Flxpoint support to investigate further, as the issue may persist after initial fixes.
- Mismatched Titles and Variant Structures: Publishing errors can occur if parent titles or variant structures differ between Flxpoint and Shopify. For example, if Flxpoint has a parent title "Tranquility 3XL Disposable Bariatric Adult Briefs" but Shopify has "Tranquility HI-Rise 3XL Disposable Bariatric Adult Briefs," the handles will differ, and variants may be distributed across multiple parent products in Shopify (e.g., 2190-Case in one product, 2192-Pack in another). To resolve, align the product variant structure in Shopify to match Flxpoint by ensuring titles and variant groupings are consistent. Note: Parent titles are not critical for linking itself, so differing titles alone may not cause issues unless variants are distributed across multiple parents.
- Variant Count Differences: If a product has a different number of variants in Flxpoint vs. Shopify (e.g., 1 variant in Flxpoint but 12 in Shopify for SKU SME25BS1-Case), this does not typically affect publishing as long as the linked variant’s identifier matches. The process should work fine, and the number of sibling variants in Shopify is not a concern for linking.
- Price/Quantity Sync Errors During Publishing: Even if titles match between Flxpoint and Shopify, price or quantity sync errors can occur during publishing due to structural differences in how products are organized (e.g., differing parent-variant relationships). If this happens, contact Flxpoint support, as it may require a deeper investigation to resolve the mismatch. Note: This issue may also appear when syncing orders; see the "Sync Orders" section for additional troubleshooting steps.

9. Conclusion
The Shopify Publish Listings integration streamlines the process of managing your Shopify store inventory from Flxpoint. With support for variants, metafields, and automated scheduling, it ensures your product data is accurately published while adhering to Shopify’s limits and requirements.
 
 


 

Order Operations

Get Orders

Supported | Shopify - Get Orders

1. Introduction to Shopify Get Orders
The Shopify Get Orders integration allows Flxpoint to retrieve new orders from your Shopify store that have not yet been imported. It also sends back acknowledgments for successfully imported orders by tagging them in Shopify. This integration is designed for businesses to streamline order management by centralizing Shopify orders into Flxpoint for fulfillment and inventory tracking.

2. Why Use This Integration?
This integration offers key benefits:
- Order Retrieval: Imports new Shopify orders into Flxpoint based on selected financial and fulfillment statuses.
- Multi-Location Support: Supports Shopify’s multi-location inventory using Custom Aggregate Fields (CAFs) for precise inventory and order management.
- Custom Fields: Imports custom fields for order line items if configured in the mapping template.
- Digital Items: Supports digital items in orders, ensuring comprehensive order management.
- Order Acknowledgment: Tags successfully imported orders in Shopify for easy tracking.

3. How the Integration Works
The integration follows these steps to retrieve orders:
1. Fetch Orders: Flxpoint sends a GET request to the Shopify endpoint /admin/api/{version}/orders.json, filtering by financial status, fulfillment status, and since_id to retrieve new or updated orders within a specified time frame (e.g., last 14 days).
2. Filter Orders: Applies filters for financial status (e.g., Paid) and fulfillment status (e.g., Unfulfilled), excluding orders with "Scheduled" or "On hold" statuses.
3. Map Data: Uses a mapping template to align Shopify order data with Flxpoint fields, such as billing/shipping addresses and line items.
4. Handle Locations: Marks orders as non-shippable in Flxpoint if a Location ID is missing, unless "Import Orders with No Location ID" is enabled. Orders with a different Location ID than the configured one are saved in Flxpoint.
5. Acknowledge Orders: Optionally tags imported orders in Shopify with a custom tag (e.g., "Received by Flxpoint") to confirm successful import.

4. Configuration Options
Customize the integration to fit your needs:
- Connection: Select your Shopify store connection (e.g., "Shopify Connection API - Shopify App (OAuth2)").
- Location ID: Specify the inventory location ID in Shopify for order imports (required unless "Import Orders with No Location ID" is enabled).
- Financial Status: Filter orders by financial status (e.g., Any, Authorized, Pending, Paid, Partially Paid, Refunded, Partially Refunded, Voided, Unpaid). Most users default to all statuses.
- Fulfillment Status: Filter orders by fulfillment status:
- Unfulfilled: Imports orders that have not been shipped.
- Partially Fulfilled: Imports orders that have been partially shipped.
- Fulfilled: Imports orders that have been fully shipped.
- Get Orders Updated Within the Last X Days: Set the time frame for retrieving updated orders (default: 14 days).
- Upload Tag to Shopify Order After Importing: Optionally add a tag (up to 20 characters) to imported orders in Shopify (e.g., "Received by Flxpoint").
- Personal Identifying Information Retention: Control how long personal identifying information is retained in Flxpoint (default: Indefinitely).
- Import Orders with No Location ID: Enable to import orders without a Location ID; if disabled, such orders are ignored unless they match the configured Location ID.
- Mapping Template: Define how Shopify order fields map to Flxpoint fields (details below).

5. Step-by-Step Setup Instructions
Follow these steps to set up the integration:
1. Add the Integration: In Flxpoint, go to the "Integrations" section, select "Shopify" as the type, and choose "Get Orders."
2. Connect to Shopify: Select an existing Shopify connection or set up a new one using your Shopify credentials.
3. Configure Settings: Specify the Location ID, select financial and fulfillment statuses (e.g., Paid and Unfulfilled), set the time frame for updates (e.g., 14 days), and optionally enable "Import Orders with No Location ID" and add an upload tag (e.g., "Received by Flxpoint").
4. Create a Mapping Template: Define how Shopify fields map to Flxpoint fields, such as mapping Shopify Billing Address fields to Flxpoint address fields (see below).
5. Run the Integration: Click "Run Integration" to retrieve orders manually.

6. Mapping Template: Importing Shopify Orders to Flxpoint
A mapping template ensures Shopify order data transfers correctly to Flxpoint, such as mapping Shopify’s billing address fields to Flxpoint’s address fields.
6.1 Interface Overview
- Top Section: Labeled "Mapping Template," like "Get Orders 1."
- Buttons: Delete to remove the template, Duplicate to copy it, and Save to save changes.
- Mapping Sections:
- From Value: Shopify fields, like Shopify Billing Address, Shopify Order, or Shopify Line Item fields.
- To Flxpoint Field: Flxpoint fields, like Billing Address, Shipping Address, or Order Line Items.
6.2 Mapping Options
For each field, choose from:
- Don’t Map: Skip the field—no data is imported into Flxpoint.
- Set To Empty: Clear the field in Flxpoint, removing existing data.
- Field: Map a Shopify field to a Flxpoint field, like mapping "Shopify Billing Address - Address 1" to "Flxpoint Billing Address - Address 1."
- Value: Set a fixed value for a Flxpoint field.
- Rules: Apply conditional logic to customize the mapping.
6.3 Available Source Fields in Shopify
Shopify fields include:
- Shopify Billing/Shipping Address: Address 1, Address 2, City, Company, Country, Country Code, Province, Province Code, Zip, Name, Phone.
- Shopify Order: ID, Name, Order Number, Email, Currency, Total Price, Total Discounts, Shipping Price, Fulfillment Status, Created At, Updated At, Tags, Note.
- Shopify Line Item: SKU, Quantity, Price, Total Discount, Fulfillable Quantity, Fulfillment Status, Properties (custom fields).
6.4 Suggested Mappings
6.4.1 Billing/Shipping Address Fields
- Address 1: Map to "Shopify Billing/Shipping Address - Address 1."
- City: Map to "Shopify Billing/Shipping Address - City."
- Province Code: Map to "Shopify Billing/Shipping Address - Province Code."
- Zip: Map to "Shopify Billing/Shipping Address - Zip."
6.4.2 Order Fields
- Order Number: Map to "Shopify Order - Order Number."
- Total Price: Map to "Shopify Order - Total Price."
- Shipping Price: Map to "Shopify Order - Shipping Price."
6.4.3 Line Item Fields
- SKU: Map to "Shopify Line Item - SKU."
- Quantity: Map to "Shopify Line Item - Quantity."
- Custom Fields: Map to "Shopify Line Item - Properties" for custom fields.

7. Multi-Location and Shopify Locations
Shopify supports multi-location inventory, which Flxpoint leverages using Custom Aggregate Fields (CAFs):
- Key Features: Manage inventory across multiple warehouses or fulfillment locations, and customize workflows using CAFs for precise inventory and order management.
- Location Priority: Shopify’s location settings prioritize fulfillment from internal inventory first. Refer to Shopify’s guide on setting the priority of locations for fulfilling orders to configure this correctly before orders are imported into Flxpoint.

8. Limitations
Be aware of the following constraints:
- Linked SKU Issue: A "Linked" SKU may import as "Not Managed." Unlink and relink the SKU to update the Internal ID value.
- Location ID Requirement: Flxpoint requires a Location ID for order imports unless "Import Orders with No Location ID" is enabled.
- Order Updates: Flxpoint imports order data once; changes made to the order in Shopify afterward will not update the order in Flxpoint.
- SKU Requirement: Order items without SKUs will not be imported by Flxpoint. If a product lacks a SKU, Flxpoint imports it as "Non-Managed" using the product’s "Title" as the SKU.
- Unsupported Statuses: Orders with "Scheduled" (prepaid subscriptions) or "On hold" (upsell offers or manual holds) fulfillment statuses are not imported by Flxpoint.

9. Troubleshooting Common Issues
Address common issues with these steps:
- Order Not Imported: Check if the order’s financial or fulfillment status matches the configured filters (e.g., Paid, Unfulfilled). Ensure the order is not in "Scheduled" or "On hold" status, as these are not supported.
- Missing SKU: Verify that all line items have a SKU in Shopify; if not, Flxpoint will not import the order.
- Location ID Errors: Ensure the Location ID is configured correctly in Flxpoint, or enable "Import Orders with No Location ID" to include orders without a location.
- Order Data Incomplete: Confirm that the shipping address and SKU are available for all line items in the order, as these are required for import.

10. Conclusion
The Shopify Get Orders integration simplifies order management by importing Shopify orders into Flxpoint, supporting multi-location inventory, custom fields, and digital items. With flexible configuration options and mapping templates, it ensures accurate order data transfer while adhering to Shopify’s requirements and Flxpoint’s limitations.
 
 

Sync Orders

Supported | Shopify - Sync Orders

1. Introduction to Shopify Sync Orders
The Shopify Sync Orders integration enables Flxpoint to send shipment updates back to Shopify, updating fulfillment details such as tracking numbers and carrier information. It also supports syncing a "Closed" order status for orders with partial or no fulfillment data, including In-Store orders that are auto-closed after fulfillment. This integration is designed for businesses to keep Shopify orders aligned with Flxpoint’s fulfillment processes, ensuring accurate tracking and order status updates across all sales channels, whether online or in-store.

2. Why Use This Integration?
This integration offers key benefits:
- Update Fulfillment Details: Syncs shipment details like tracking numbers, tracking URLs, and carrier information to Shopify.
- Order Status Updates: Optionally syncs a "Closed" status to Shopify for orders with partial or no fulfillment data, archiving future orders from Shopify. This is particularly useful for In-Store orders that auto-close after fulfillment.
- Multi-Location Support: Handles Shopify’s multi-location inventory, ensuring shipments are associated with the correct Location ID.
- Partial Shipments: Supports partial shipments, updating Shopify with "Partially Shipped" status until the order is fully shipped ("Shipped").
- Customer Notifications: Allows notifying customers of shipment updates via Shopify, configurable in the mapping template.

3. How the Integration Works
The integration follows these steps to sync orders:
1. Send Fulfillment Data: Flxpoint sends a POST request to the Shopify endpoint /admin/api/{version}/fulfillments.json, including fulfillment details for a specified order_id.
2. Handle Multi-Location: If an order has items from multiple locations, Flxpoint syncs shipments only for items from the same location. If a shipment fails for items in another location, it retries in the next sync job.
3. Map Data: Uses a mapping template to align Flxpoint shipment data with Shopify fulfillment fields, such as tracking number and carrier.
4. Update Order Status: Updates Shopify with "Partially Shipped" for partial shipments or "Shipped" for complete shipments. Optionally syncs a "Closed" status for orders with partial or no fulfillment data if enabled, including In-Store orders that are auto-closed after fulfillment in Flxpoint.
5. Notify Customer: Optionally notifies the customer of shipment updates, configurable via the mapping template (default: False if not mapped).

4. Configuration Options
Customize the integration to fit your needs:
- Connection: Select your Shopify store connection (e.g., "Shopify Connection API - Shopify App (OAuth2)").
- Location ID: Specify the inventory location ID in Shopify for syncing fulfillments (required).
- Sync "Closed" Order Status Back to Shopify: Enable to send a "Closed" status for orders with partial or no fulfillment data, archiving future orders from Shopify (default: No). This is particularly relevant for In-Store orders, which auto-close after fulfillment and can have their status synced to Shopify.
- Shipping Mappings: Map Shopify’s shipping rates (e.g., Free, Expedited, Standard) to Flxpoint’s shipping policies (e.g., Ground, Two Day Shipping) to ensure orders are imported with the correct shipping policy in Flxpoint. For In-Store orders, ensure the Channel Shipping Text (e.g., "In-Store" or "POS") is mapped appropriately to identify them correctly.
- Mapping Template: Define how Flxpoint shipment fields map to Shopify fulfillment fields (details below).

5. Step-by-Step Setup Instructions
Follow these steps to set up the integration:
1. Add the Integration: In Flxpoint, go to the "Integrations" section, select "Shopify" as the type, and choose "Sync Orders."
2. Connect to Shopify: Select an existing Shopify connection or set up a new one using your Shopify credentials.
3. Configure Settings: Specify the Location ID, enable "Sync 'Closed' Order Status Back to Shopify" if needed (especially for In-Store orders that auto-close), and set up shipping mappings in the "Shipping Mappings" section (e.g., map Shopify’s "Expedited" to Flxpoint’s "Two Day Shipping"). For In-Store orders, ensure the Channel Shipping Text (e.g., "In-Store") is defined to align with your In-Store Order Workflow rules.
4. Create a Mapping Template: Define how Flxpoint shipment fields map to Shopify fulfillment fields, such as mapping "Shipment - Tracking Number" to "Shopify Fulfillment - Tracking Number" (see below).
5. Run the Integration: Click "Run Integration" to sync shipment updates manually.

6. Shipping Mappings
Shipping mappings ensure orders imported from Shopify are aligned with a central shipping policy in Flxpoint:
6.1 Configure Shipping Rates in Shopify
In Shopify, navigate to Settings → Shipping and Delivery → General Shipping Rates to manage your rates. Available rates for Domestic shipping might include:
- Expedited: $9.90 for 5lb–10lb.
- Free: Free for 0lb–1lb.
- Standard: $3.95 for $0.00–$30.00.
6.2 Map Shopify Rates to Flxpoint Policies
In Flxpoint, go to the "Shipping Mappings" section to map Shopify’s shipping rates to Flxpoint’s shipping 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.
6.3 In-Store Order Shipping Text
For In-Store orders, ensure the Channel Shipping Text (e.g., "In-Store" or "POS") is defined in Shopify and mapped in Flxpoint to identify these orders correctly. This text should match the conditions set in your In-Store Order Workflow rules to ensure proper designation and fulfillment before syncing.

7. Mapping Template: Syncing Flxpoint Shipments to Shopify
A mapping template ensures Flxpoint shipment data transfers correctly to Shopify, such as mapping "Shipment - Tracking Number" to Shopify’s fulfillment fields.
7.1 Interface Overview
- Top Section: Labeled "Mapping Template," like "Sync Orders 1."
- Buttons: Delete to remove the template, Duplicate to copy it, and Save to save changes.
- Mapping Sections:
- From Value: Flxpoint fields, like Shipment fields (e.g., Tracking Number, Carrier).
- To Shopify Field: Shopify fulfillment fields, like Tracking Number, Tracking URL, or Notify Customer.
7.2 Mapping Options
For each field, choose from:
- Don’t Map: Skip the field—no data is sent to Shopify.
- Set To Empty: Clear the field in Shopify, removing existing data.
- Field: Map a Flxpoint field to a Shopify field, like mapping "Shipment - Tracking Number" to "Shopify Fulfillment - Tracking Number."
- Value: Set a fixed value, such as setting "Notify Customer" to "True" or "False."
- Rules: Apply conditional logic to customize the mapping (not always available).
7.3 Available Source Fields in Flxpoint
Flxpoint fields under "Shipment" include:
- Carrier (Text)
- Fulfillment Request Number (Text)
- Method (Text)
- Note (Text)
- Shipped At (Date)
- Shipping Cost (Number)
- Tracking Number (Text)
- Tracking URL (Text)
7.4 Shopify Fulfillment Fields and Suggested Mappings
7.4.1 Shopify Fulfillment Fields
- Location ID: The Shopify location ID for the fulfillment.
- Suggested Mapping: Typically set to "Don’t Map" as it’s handled by the integration’s Location ID setting.
- Notify Customer: Boolean value to notify the customer of the shipment update.
- Suggested Mapping: Set to a fixed value (e.g., "True" or "False"). Default is "False" if not mapped.
- Tracking Company: The carrier name for the shipment.
- Suggested Mapping: Map to "Shipment - Carrier."
- Example: If the carrier in Flxpoint is "UPS," this updates the Tracking Company to "UPS" in Shopify.
- Tracking Number: The tracking number for the shipment.
- Suggested Mapping: Map to "Shipment - Tracking Number."
- Tracking URL: The URL for tracking the shipment.
- Suggested Mapping: Map to "Shipment - Tracking URL."

8. Multi-Location Support
Shopify supports multi-location inventory, which Flxpoint leverages for accurate fulfillment:
- Location ID Requirement: A Location ID must be specified in Flxpoint to sync fulfillments. Refer to Shopify’s guide on managing locations to set up and prioritize locations.
- Multi-Location Shipments: If an order has items from multiple locations, Flxpoint syncs shipments only for items from the same location. Failed shipments for other locations are retried in the next sync job. This applies to both online and In-Store orders, ensuring accurate fulfillment across all locations.

9. Limitations
Be aware of the following constraints:
- Manual Order Item Limitations: Flxpoint does not support manual order item limitations for syncing shipments.
- Sync "Closed" Limitation: Enabling "Sync 'Closed' Order Status" only affects future orders from Shopify, not existing ones. However, for In-Store orders, this can be used to reflect their auto-closed status in Shopify after fulfillment.

10. Troubleshooting Common Issues
Address common issues with these steps:
- Shipment Not Syncing: If a shipment isn’t syncing, it may be due to Shopify not recognizing an item (e.g., the product was deleted). Example: If Product X was ordered on Tuesday, deleted on Wednesday, and shipped on Thursday, Shopify will throw an error ("Product X cannot be located"). This often stems from a linking issue that should be resolved during publishing; see the "Publish Listings" section for steps to unlink and re-link the product to resolve this issue.
- Multi-Location Errors: Ensure the correct Location ID is specified in Flxpoint. If an order has items from multiple locations, verify that shipments are available for all items in the configured location. For In-Store orders, confirm that the fulfillment source matches the Location ID used in your In-Store Order Workflow settings.
- Customer Not Notified: Check the mapping template to ensure "Notify Customer" is set to "True" if notifications are desired.
- Additional Sync Errors: For issues like "Product variant does not exist," mismatched titles, or structural differences causing price/quantity sync errors, refer to the "Publish Listings" section. These errors often originate from product linking issues during publishing, which must be resolved before syncing orders.

11. Conclusion
The Shopify Sync Orders integration ensures seamless fulfillment updates between Flxpoint and Shopify, supporting multi-location inventory, partial shipments, customer notifications, and In-Store orders. With shipping mappings and a flexible mapping template, it keeps your Shopify orders aligned with Flxpoint’s fulfillment processes while adhering to Shopify’s requirements.
 
 

 

How can I help?