How should an integration between RetailVIsta and Shopware be set up?

This document describes what is needed to set up integration with a Shopware webshop within RetailVista

Creating a webshop in RetailVista

First, it is important to create a webshop with webshop type Shopware v6. Only version 6 is currently implemented.

Enter the ApiUrl in the 'integration' tab. This is the URL of the website with /api appended.

Enter the ClientId in the username field and the client secret in the password field.

In the export and orders tab, you can specify whether articles should be sent to Shopware and whether orders should be retrieved.

No separate task schedules need to be created. The regular webshop-sync task schedules for order and article sync will also process this webshop.

Article export

The following fields are currently offered to Shopware:

- Ean

- Name (article description)

- ProductNumber

- Note1, Note2, Note3, and Note4. These are offered as CustomFields

- Free fields. These are also offered as customfields. The name of the free field becomes the name of the customfield.

- Stock (free stock - threshold stock)

- Tax

- Delivery time (number of days, from supplier or purchase)

- Price (gross price of article)

- Listprice (recommended retail price)

- Category (webshop classification)

- Ordercode (as customfield)

- Discounts from-to:

Changes in active article discounts are immediately included in the article sync. These are offered as 'AdvancedPrice' within Shopware.
A from-to price is offered with a price range that matches the from-to price specified.So at a price of €4.00 per 4, you will get a quantity from of 4 and a quantity to of 4.

With a tier, for example from 2 pieces at €3.00 each, only the quantity-from field is filled in the number field:  

Every night a complete discounts synchronization takes place. This performs 2 bulk actions:

1. Discounts that have become active (but not changed), for example because the start date has started, are sent

2. Discounts that have become inactive (for example, the promotion has expired, or the discount has been removed from RV) are removed.

So every night a complete synchronization of active discounts takes place, and during the day all modified discounts are included in the article sync.

A condition for creating discounts is that there is a rule present in Shopware with the name "RetailVista". A rule is mandatory in Shopware for advanced prices, and this rule is used by default to link the discounts. The rule can be kept very simple, always applicable without any restriction:

Fetching orders

Every order synchronization retrieves orders from Shopware. There is a 10-minute overlap to prevent gaps. Orders that have already been retrieved and processed are skipped.

The most important data retrieved from an order:

- Customer

- BillingAddress

- DeliveryAddress

- Transactions (payments)

- Rules

The order number from Shopware is taken as the reference code. This is a recognizable field that allows the order to be easily found in Shopware.

For payments and shipping methods, it is important that the names from Shopware match the codes of the payment methods and transport types.