# Shopify & Descartes Peoplevox

## Overview

The **Shopify & Descartes Peoplevox** blueprint includes everything you need to:

* Sync products from Shopify to Peoplevox
* Sync orders from Shopify to Peoplevox
* Sync stock from Peoplevox events to Shopify
* Sync refunds (using returns report data) from Peoplevox to Shopify
* Sync fulfilments from Peoplevox events to Shopify
* Subscribe to Peoplevox fulfilment post events
* Subscribe to Peoplevox stock events (using site filters)
* Unsubscribe from Peoplevox events

## Installed process flows

Process flows are built to implement powerful data flows between connector instances in an intuitive, visual way - this is where we define if, when, what, and how data is synced. All process flows installed with this blueprint are shown below.

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Orders: Shopify -> PVX - Targeted Sync</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FPGW5sxXwCQRGAJnRYwqx%2Fflow%201%20-%20Orders-%20Shopify%20-%3E%20PVX%20-%20Targeted%20Sync.png?alt=media\&token=ac883026-b7c3-455e-a645-2836d2fb947d)

</details>

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Orders: Shopify -> PVX</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FWsu6aZjPTEkqp7k25n9A%2Fflow%202%20-%20Orders-%20Shopify%20-%3E%20PVX.png?alt=media\&token=4c598799-7e81-4e2f-98d1-27b59d2f88d7)

</details>

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Orders: Shopify -> PVX - Daily Sweeper</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2F8VyzaotNnSyOzxzdzhhv%2Fflow%203%20-%20Orders-%20Shopify%20-%3E%20PVX%20-%20Daily%20Sweeper.png?alt=media\&token=44d017a2-8cb5-471c-9218-951d32ed974f)

</details>

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Unsubscribe Post Events</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2Fye9zY2T2MzUk42GGpTLX%2Fflow%204%20-%20Unsubscribe%20Post%20Events.png?alt=media\&token=ccedeaa0-ffb6-4e06-8138-5d39ec760433)

</details>

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Fulfilments: PVX > Shopify Sweeper</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FPJ6zwwAr9kkBY8GKHvEk%2Fflow%205%20-%20Fulfilments-%20PVX%20%3E%20Shopify%20Sweeper.png?alt=media\&token=f0c1e4ec-39af-4054-b8cd-2832664ebe42)

</details>

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Stock: Subscribe Event Stock Updates</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FgU59UspBKVlq7jcmlU59%2Fflow%206%20-%20Stock-%20Subscribe%20Event%20Stock%20Updates.png?alt=media\&token=c4a2ab50-bdd2-49ac-968a-79787d50ca31)

</details>

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Subscribe Post Event Fulfilment</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FZXbT4YFHY3pQBTWuBeYv%2Fflow%207%20-%20Subscribe%20Post%20Event%20Fulfilment.png?alt=media\&token=047efc6d-2234-4f6b-a40c-3556b9f8b149)

</details>

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Fulfilments: PVX > Shopify -Events</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2Fm3a4MxGthLRiPA6WfPLN%2Fflow%208%20-%20Fulfilments-%20PVX%20%3E%20Shopify%20-Events.png?alt=media\&token=79ecad65-4c3e-4d92-b443-920d52a8c687)

</details>

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Refunds: PVX > Shopify</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2F9VEs0bfkRfEIXqA4eE6V%2Fflow%209%20-%20Refunds-%20PVX%20%3E%20Shopify.png?alt=media\&token=b21b314b-0178-41f0-8e69-8753f1134c46)

</details>

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Inventory/Stock: PVX EVENT > Shopify</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2F1BFa1Cv5qAvyF02QXISA%2Fflow%2010%20-%20Inventory%3AStock-%20PVX%20EVENT%20%3E%20Shopify.png?alt=media\&token=35de52b6-9550-4d46-a0cb-8f158e4d6e16)

</details>

<details>

<summary><img src="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FSUvxsp8XwrC9qsafJMIe%2Ficon%20process%20flow.svg?alt=media&#x26;token=ad1dc886-4a4e-4cad-9ad0-3d755e0f3b5a" alt="" data-size="line"> Products: Shopify -> PVX</summary>

![](https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FYvpj1A945a4WxiQpYYh3%2Fflow%201%20-%20Shopify%20%3E%20Lightspeed%20Retail%20-%20Stock.png?alt=media\&token=4313aa94-f4e4-4628-9079-97fed9bf8d4d)

</details>

{% hint style="info" %}
You'll find installed process flows in the [manage process flows area of your dashboard](https://app.wearepatchworks.com/flows). For product documentation please see [Process flows](https://doc.wearepatchworks.com/product-documentation/process-flows).
{% endhint %}

## Installed connectors

A [connector](https://doc.wearepatchworks.com/product-documentation/connectors-and-instances) is a generic integration of a third-party business system/application. Connector instances (configured by you as part of the [blueprint install process](https://doc.wearepatchworks.com/product-documentation/blueprints/patchworks-blueprints/installing-a-patchworks-blueprint), or later via your [connectors page](https://doc.wearepatchworks.com/product-documentation/connectors-and-instances/working-with-instances/adding-an-instance)), are added to process flows via the [connector shape](https://doc.wearepatchworks.com/product-documentation/process-flows/building-process-flows/process-flow-shapes/standard-shapes/connector-shape).  All connectors installed with this blueprint are shown below.

<table data-card-size="large" data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-cover data-type="files"></th></tr></thead><tbody><tr><td><a href="../../connectors-and-instances/patchworks-connectors/descartes-peoplevox-prebuilt-connector">Descartes Peoplevox</a> is the Warehouse Management System for eCommerce businesses, online retailers and direct to consumer brands.</td><td></td><td></td><td><a href="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2FibeLPBhE0lqrLag17NoA%2Fpeoplevox2.svg?alt=media&#x26;token=0234a9af-609f-46c4-9585-faf8b94103d2">peoplevox2.svg</a></td></tr><tr><td><a href="../../connectors-and-instances/patchworks-connectors/shopify-prebuilt-connector">Shopify</a> is a cloud-based, fully hosted commerce platform which can be used to create and manage online stores.</td><td></td><td></td><td><a href="https://2440044887-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLYNcUBVQwSkOMG6KjZfz%2Fuploads%2Fm1CTJOzDDCC60gkBdaRy%2Fshopify2.svg?alt=media&#x26;token=6576ee77-1607-4862-b44b-7f595e1bdf19">shopify2.svg</a></td></tr></tbody></table>

{% hint style="info" %}
You'll find installed connectors in the [manage connectors area of your dashboard](https://app.wearepatchworks.com/connectors). For product documentation please see [Connectors & instances](https://doc.wearepatchworks.com/product-documentation/connectors-and-instances/connectors-and-instances-introduction).
{% endhint %}

## Installed scripts

Custom scripts are implemented via the [script shape](https://doc.wearepatchworks.com/product-documentation/process-flows/building-process-flows/process-flow-shapes/advanced-shapes/script-shape), and are typically used when source data needs to be manipulated beyond the capabilities that standard [transform functions](https://doc.wearepatchworks.com/product-documentation/process-flows/building-process-flows/process-flow-shapes/standard-shapes/map-shape/working-with-field-transformations) provide. All scripts installed with this blueprint are shown below.

| Script                                | Summary                                              |
| ------------------------------------- | ---------------------------------------------------- |
| Format to PVX Data                    | Format json to Peoplevox data.                       |
| Strip Data Array                      | Strips data array for graphQL request.               |
| Format PVX Event Fulfilment Data      | Formats event fulfilment data to line items array.   |
| Set PVX Time Filter                   | Sets a time filter variable in Peoplevox format.     |
| PVX XML to JSON                       | Formats Peoplevox data into json.                    |
| PVX Returns Combine Report Data Lines | Combines report data by sales order number.          |
| Calculate Shopify Refunds             | Calculates refunds from suggested refund data.       |
| Flatten Products                      | Flattens products to one list of variants.           |
| Generate Sku Query                    | Generates a Shopify GraphQL query for provided SKUs. |
| Calculate Inventory Adjust            | Calculates inventoryItemAdjustments.                 |
| Combine Fulfilment Lines              | Combines report data by sales order number.          |

{% hint style="info" %}
You'll find installed scripts in the [scripts area of your dashboard](https://app.wearepatchworks.com/scripts). For product documentation please see [Custom scripting](https://doc.wearepatchworks.com/product-documentation/developer-hub/custom-scripting).
{% endhint %}

## Installed cross-reference lookups

Cross-reference lookups are used for cases where some values are commonly known by other terms. If source data includes values that always need to be changed to an alternative term, a [cross-reference lookup](https://doc.wearepatchworks.com/product-documentation/marketplace/marketplace-cross-reference-lookups) can be used to [transform](https://doc.wearepatchworks.com/product-documentation/process-flows/cross-reference-lookups/using-a-cross-reference-lookup-in-field-transformations) required data fields (via the [map](https://doc.wearepatchworks.com/product-documentation/process-flows/building-process-flows/process-flow-shapes/standard-shapes/map-shape) shape). All cross-reference lookups installed with this blueprint are shown below.

| Cross-reference lookup name | Cross-reference lookup description                     |
| --------------------------- | ------------------------------------------------------ |
| N/A                         | This app does not include any cross-reference lookups. |

{% hint style="info" %}
You'll find installed cross-reference lookups in the [cross-reference lookups area of your dashboard](https://app.wearepatchworks.com/cross-reference-lookups). For product documentation please see [Cross-reference lookups](https://doc.wearepatchworks.com/product-documentation/marketplace/marketplace-cross-reference-lookups).
{% endhint %}

## Installed caches

Caches are specified in the [add to cache shape](https://doc.wearepatchworks.com/product-documentation/process-flows/building-process-flows/process-flow-shapes/advanced-shapes/cache/add-to-cache-shape), and used to store data (temporarily) at given points in a process flow. Typically, this is done so the data at that point in time can be referenced later in the same process flow, or by other process flows, via a [load from cache shape](https://doc.wearepatchworks.com/product-documentation/process-flows/building-process-flows/process-flow-shapes/advanced-shapes/cache/load-from-cache-shape). All caches installed with this blueprint are shown below.

| Cache name               | Cache type |
| ------------------------ | ---------- |
| Stock Event Data         | Flow run   |
| Original Return Data     | Flow run   |
| Original Fulfilment Data | Flow run   |
| Fulfilment Order Line ID | Flow run   |
| Order Data               | Flow run   |

{% hint style="info" %}
You'll find installed caches in the [data caches area of your dashboard](https://app.wearepatchworks.com/caches). For product documentation please see [Cache shapes](https://doc.wearepatchworks.com/product-documentation/process-flows/building-process-flows/process-flow-shapes/advanced-shapes/cache).
{% endhint %}

## Installed data pools

Data pools are used by the [de-dupe shape](https://doc.wearepatchworks.com/product-documentation/process-flows/building-process-flows/process-flow-shapes/advanced-shapes/de-dupe-shape) in process flows. They store unique key field values that have passed through the shape, so subsequent records can be checked and matched for duplication. All data pools installed with this blueprint are shown below.

| Data pool name | Unique key  | Applicable process flows                           |
| -------------- | ----------- | -------------------------------------------------- |
| Returns ID     | return code | [Refunds: PVX > Shopify](#installed-process-flows) |
