Sales orders are pulled from Virtualstock Supplier and created in Shopify with a paid and unfulfilled status. Finally, an acknowledgement is sent back to Virtualstock Supplier.
Any orders with an ORDER status are pulled from Virtualstock Supplier. Once an order is successfully sent into Shopify, we send an ORDER_ACK back to Virtualstock Supplier - the order is then moved into ORDER_ACK status so that it won't be picked up in subsequent flow runs.
The operations count for this process flow is: 4 per order.
For reference, all shapes in this process flow are documented below. Do not change shape settings unless advised to do so in our installation guide.
| Shape | Notes |
|---|---|
| Script | Summary |
|---|---|
| Cross-reference lookup | Summary |
|---|---|
Trigger
Having installed the blueprint, edit this shape and define your preferred run schedule. Please see the installation guide for specific notes.
Connector
If instance credentials are provided as part of the blueprint installation, there should be no need to change any settings for this shape. For reference, the required settings are:
Source instance: Virtualstock Supplier
Source endpoint: GET List orders
Variables: Set as Status / ORDER
Flow control
There should be no need to change any settings for this shape. For reference, required settings are:
Source instance: Virtualstock Supplier
Source endpoint: GET List orders
Batch level: *
Batch size: 1
Map
Generally, field mappings should not be changed. However please refer to the installation guidelines for this process flow for any fields that are noted for special attention.
Source instance: None
Source endpoint: None
Add to cache
These settings should not be changed. For reference, required settings are:
Cache: (Flow run) VSSalesOrder
Cache key: VSSalesOrder
Append: OFF
Save all pages: OFF
Script
These settings should not be changed. For reference, required settings are:
Script: SKU Search Script
Version: v3 (latest)
Connector
If instance credentials are provided as part of the blueprint installation, there should be no need to change any settings for this shape. For reference, the required settings are:
Source instance: Shopify
Source endpoint: POST Get VariantID by SKU - GraphQL
Variables: Set as Query String / [[payload.productCodeString]]
Add to cache
These settings should not be changed. For reference, required settings are:
Cache: (Flow run) VSSalesOrder
Cache key: VSSalesOrder
Append: ON
Path to append to: SKUData
Save all pages: OFF
Load from cache
These settings should not be changed. For reference, required settings are:
Cache: (Flow run) VSSalesOrder
Cache key: VSSalesOrder
Fail on cache miss: OFF
Load all pages: OFF
Script
These settings should not be changed. For reference, required settings are:
Script: Match Shopify Variant to SKU
Version: v3 (latest)
Connector
If instance credentials are provided as part of the blueprint installation, there should be no need to change any settings for this shape. For reference, the required settings are:
Source instance: Shopify
Source endpoint: POST Create an order
Route
If instance credentials are provided as part of the blueprint installation, there should be no need to change any settings for this shape. For reference, the required settings are:
Source instance: Virtualstock Supplier
Source endpoint: N/A
Routing method: Follow all matching routes
Route 1: No Errors
Route 2: Error
Route 1
Payload fields: order.id
Type: Null comparison
Operator: Not NULL
Keep matching: ON
Route 2
Payload fields order.id
Type: Null comparison
Operator: Is NULL
Keep matching: ON
(Route 1) Script
These settings should not be changed. For reference, required settings are:
Script: Save Order URI ID to Meta Var
Version: v6 (latest)
(Route 1) Map
Generally, field mappings should not be changed. However please refer to the installation guidelines for this process flow for any fields that are noted for special attention.
Source instance: None
Source endpoint: None
(Route 1) Connector
If instance credentials are provided as part of the blueprint installation, there should be no need to change any settings for this shape. For reference, the required settings are:
Source instance: Virtualstock Supplier
Source endpoint: POST Acknowledge an order
Variables: Set as Order URI / [[meta.VSorderId]]
(Route 2) Connector
These settings should not be changed. For reference, required settings are:
Expected Payload: Order failed to create if reached here.
Phone Number Formatter
Corrects formatting for UK telephone numbers.
SKU Search Script
Creates GraphQL input for Shopify.
Match Shopify Variant Id to SKU
Replaces sales order SKUs with variant Ids.
Save Order URI ID to Meta Var
Extracts URI from Shopify notes.
Calculate dispatch date using orderDate
Takes Shopify's order created date and adds 5 days to calculate the supplier delivery date. If required, you can change the number of days used for this calculation - please see the installation guide for details.
Carrier map
Maps Shopify tracking companies to Virtualstock carriers (and vice versa). You need to update this table with your own values - please see the installation guide for details.
SKU Lookup
Maps Virtualstock Supplier part numbers to Shopify SKUs. You need to update this table with your own values - please see the installation guide for details.
