Available process flows (Shopify & NetSuite
Introduction
This section provides a technical overview of process flows included with the Shopify & NetSuite blueprint.
Available process flows
Retrieves all locations from Shopify and then checks which ones exist in NetSuite. In NetSuite, new locations are created, and address details for existing locations are updated.
Retrieves all locations from NetSuite and then checks which ones exist in Shopify. In Shopify, new locations are created, and address details for existing locations are updated.
Retrieves new and updated products from Shopify and then checks which ones exist in NetSuite. In NetSuite, new products are created, and existing products are updated.
Retrieves new and updated companies from NetSuite. If the company name does not exist in Shopify, a new company is created; if the company name exists in Shopify, any new or updated contacts/addresses are added.
Updates NetSuite with new/updated companies from Shopify. Payment terms are not synced.
Retrieves orders from Shopify that were created in a paid or pending state, based on the order's financial status. Depending on this state, orders are created or updated.
Retrieves NetSuite orders fulfilled in the last day. Anything that is not in a shipped state is removed and remaining data is cached. We then retrieve and cache required details from Shopify, and the final cache is pushed to Shopify (sending fulfilment IDs and tracking numbers).
Shopify retrieves fulfilled/partially fulfilled orders created after a given date, with a financial status of authorized, paid or pending. This data is compared with Netsuite - if the order is not in a fulfilled state, the item fulfillment is pushed with a shipped status. Partial fulfillments are supported.
Shopify orders last modified after a given date, and in a refunded state are retrieved. The flow then searches for matching orders in NetSuite, retrieving order details and order lines. Next, a
script determines which specific lines are being refunded by matching the return lines with their SKUs. It then creates an RMA (Return Merchandise Authorisation) from the sales order, followed by a credit memo.
This flow starts by preparing SKUs and variant IDs to support catalogue creation. Catalogues are then retrieved from NetSuite, via a custom field. Having searched Shopify catalogues, a script determines whether new or updated catalogues are needed.
Current pending orders are retrieved from Shopify, before searching NetSuite for a corresponding payment. If a match is found, the order is updated as paid.
Items with quantity updates are retrieved from NetSuite and cached. A script extracts unique SKUs and builds a query string to look up these products in Shopify, then the data is filtered and appended to the cache. Shopify inventory data is then compared with cached NetSuite items to determine quantity updates.
Retrieves price lists and associated prices from Shopify, and removes duplicate items, before pulling items from NetSuite (using UPC codes).
Next, a script matches Shopify SKUs to NetSuite items and inventory item price lists are updated.
Last updated
Was this helpful?