SPoCC Connector

SPoCC and PlentyONE – a great combination. Do you already use SPoCC as an inventory management tool for shoe retail? And are you ready to get started in e-commerce with PlentyONE? Then you’re in the right place. The SPoCC plugin connects your SPoCC system to PlentyONE.

  • Continue using SPoCC for your sales.

  • Import the item data imported in the SPoCC database to PlentyONE.

  • Modify the item data in PlentyONE as needed and then sell your items on various marketplaces, sales channels and online shops.

  • Export order data to SPoCC.

This manual page is right for you if you are a SPoCC customer but do not yet use PlentyONE productively. Do you already use PlentyONE and want to get started on SPoCC? Then contact our setup team.

1. Data exchange

After you have set up the interface to SPoCC, the automatic processes described in Table 1 are available.

Table 1. Data exchange
Data Interval

Import of new items to PlentyONE
Master data: EAN, name, itemnumbers, colour, size, etc.

Once every 24 hours

Import of additional item data to PlentyONE.
SPoCC attributes in properties

Every 60 minutes

Import of images to PlentyONE

Every 60 minutes

Import of prices to PlentyONE

  • Complete import every 24 hours

  • Changed data every 15 minutes

Import of stock details to PlentyONE

  • Complete import every 24 hours

  • Changed data every 15 minutes

Export of orders to SPoCC:

  • Create order, notifications, reserve stock

  • Update order when ready four shipping

When event procedure is triggered

Request order status:

  • Cancellation

Every 20 minutes

Provide shipping documents

When event procedure is triggered

2. Requirements

This page assumes that you are already a customer of SPoCC and PlentyONE. Have your access data for both systems at hand. While setting up the interface, you will enter your access data to make the connection.

Furthermore, you will map your SPoCC barcodes, sales prices, categories, etc. to those in PlentyONE. If you have not set up your PlentyONE system yet, then you should create the following data before you continue:

3. Downloading and installing the plugin

The SPoCC plugin is available on plentyMarketplace. The plugin connects your SPoCC system to PlentyONE.

The SPoCC plugin offers the following functionality:

  • Import items: Item data is exported from SPoCC to PlentyONE. You decide which item data is sent to PlentyONE and how the items are structured there.

  • Export orders: Order data is transmitted from PlentyONE to SPoCC. PlentyONE notifies SPoCC of the sale and automatically books the revenue into the correct SPoCC sales store.

  • Update stock levels and prices: Whenever stock levels or prices are updated in SPoCC, this information is transmitted to PlentyONE.

Step-by-step instructions

  1. Download the SPoCC plugin from plentyMarketplace.
    → If prompted, sign into plentyMarketplace. Use the same access data as for the “My account” area.

  2. Go to Plugins » Plugin set overview. Plugins can only be used as part of a plugin set. Therefore:

    1. Option A: Create a completely new plugin set. To do so, click on Add plugin set and enter a name.

    2. Option B: Create a copy of an existing plugin set. To do so, go to the Actions column and click on Copy plugin set ().

    3. Option C: Decide which existing plugin set is suitable for the SPoCC plugin.

  3. Open the plugin set by clicking on the line in the table.
    → The plugin set opens.

  4. Click on Add plugin.

  5. Select the SPoCC plugin from the plugin list.
    → Information about the plugin is displayed.

  6. Select the version you want to install from the Select version drop-down list. The newest version is selected by default.

  7. To install the plugin, click on Install.
    → The plugin is installed.
    → After installation has finished, the plugin set opens.

  8. Switch the plugin to active ().

  9. Deploy the plugin set ().

Are you new to plugins? The plugins chapter of the manual teaches you more about plugins and how they work in PlentyONE.

Interface is set up in the assistant

You do not need to configure any settings directly in the plugin. Instead, open the assistant. The assistant guides you through the setup process.

4. Completing the assistant

The assistant helps you specify how PlentyONE and SPoCC communicate with each other. For example, you’ll decide which item data is sent to PlentyONE and how the items are structured there.

Configuring the settings in the assistant:

  1. Go to Setup » Assistants » Plugins » [Open plugin set].

  2. Click on SPoCC assistant.

  3. Follow the instructions on the screen. Information about the individual steps can be found further below on this page.

  4. In the step Summary, check your settings to makes sure they are correct.

  5. Once all of the settings are correct, click on Finalise.
    → The settings are saved.

4.1. Step "Connection"

In this step, you’ll connect PlentyONE and SPoCC. In other words, you’ll enter your access data so that PlentyONE and SPoCC can communicate with each other.

Table 2. Step "Connection"
Setting Explanation

Test mode

Test mode

Activate this option to use the test mode for exchanging data between SPoCC and PlentyONE.

Login details

Global Stock API Key
(mandatory)

Enter the key for the Global Stock API that you received from SPoCC.

Transaction Service API Key
(mandatory)

Enter the key for the Transaction Service API that you received from SPoCC.

Content Article API Key
(mandatory)

Enter the key for the Content Article API that you received from SPoCC.

Retailer ID
(mandatory)

Enter the seller ID that you received from SPoCC.

4.2. Step "Item import"

In this step, you’ll decide what the data that comes from SPoCC should look like in PlentyONE. In other words, where the data should be saved in PlentyONE.

Table 3. Options for the item import
Setting Explanation

Complete item import

Activate this option to activate the complete item import.
Important: This option is deactivated automatically after the first complete item import. As such, only new and changed item data is imported. If you need another complete item import at a later date, activate this option again and complete the assistant.

Tag for importing extended item data

This tag is used to flag variations for which additional item data is to be imported from SPoCC. Data such as EAN, images and properties is imported from SPOCC for variations that you flag with this tag.

Requirement: Have you already created the necessary tags in PlentyONE? This drop-down list only includes tags that have already been created and made available for variations.

Default category

Imagine you created a new category in SPoCC. But you forgot to map it with a corresponding PlentyONE category. If you import items from the non-mapped category, they will land in the default PlentyONE category that you select here.

Requirement: Have you already created categories in PlentyONE? This drop-down list only includes the categories that already exist in PlentyONE.

Barcode

Which PlentyONE barcode type matches your SPoCC barcode? Select the barcode type from the drop-down list.

Requirement: Have you already configured barcode types in PlentyONE? This drop-down list only includes the barcode types that already exist in PlentyONE.

Barcode as SPoCC ID

When variations are created, a unique SPoCC ID is saved as the variation number. This ID is composed of the eight digit ECC variation number and a three digit size number. However, to make sure that existing variations can also be matched correctly, you need an additional barcode type where this ID can be saved for all variations.

Requirement: Have you already configured barcode types in PlentyONE? This drop-down list only includes the barcode types that already exist in PlentyONE.

Attribute: Colour attribute

Which PlentyONE attribute matches your SPoCC colour attribute? Select the attribute from the drop-down list.

Requirement: Have you already configured attributes in PlentyONE? This drop-down list only includes the attributes that already exist in PlentyONE.

Attribute: Size attribute

Which PlentyONE attribute matches your SPoCC size? Select the attribute from the drop-down list.

Requirement: Have you already configured attributes in PlentyONE? This drop-down list only includes the attributes that already exist in PlentyONE.

4.3. Step "Sales prices"

There are three prices in SPoCC:

  • Sales price

  • Target price

  • Recommended retail price

Table 4. Mapping of sales prices
Setting Explanation

Sales price
(retailPrice)

Which PlentyONE sales price do you want to use for the sale price in SPoCC? Select the appropriate PlentyONE sales price from the drop-down list.

  • The price including VAT that the customer has to pay.

Requirement: Have you already configured sales prices in PlentyONE? This drop-down list only includes the sales prices that already exist in PlentyONE.

Target price
(targetPrice)

Which PlentyONE sales price do you want to use for the target price in SPoCC? Select the appropriate PlentyONE sales price from the drop-down list.

  • The target price is the price including VAT that you use as your regular price.

Requirement: Have you already configured sales prices in PlentyONE? This drop-down list only includes the sales prices that already exist in PlentyONE.

Recommended retail price
(recommendedRetailPrice)

Which PlentyONE sales price do you want to use for the recommended retail price in SPoCC? Select the appropriate PlentyONE sales price from the drop-down list.

  • The recommended retail price is the price including VAT that the supplier or manufacturer suggests as the regular price.

  • The recommended retail price is usually only shown if the target price is lower than the recommended retail price, i.e. to show a lower price.

Requirement: Have you already configured sales prices in PlentyONE? This drop-down list only includes the sales prices that already exist in PlentyONE.

4.4. Step "Map properties"

In PlentyONE. you use properties to handle SPoCC attributes. As such, you map PlentyONE properties to your SPoCC attributes in this step.

  1. On the very right, click on .

  2. From the drop-down list PlentyONE property on the left side, select a property.
    Requirement: Have you already configured properties in PlentyONE? This drop-down list only includes the properties that already exist in PlentyONE.

  3. From the drop-down list SPoCC attribute on the right, select an attribute.
    → The two records are mapped to each other.

  4. Map additional properties in the same way.

Table 5. Properties mapping
Setting Explanation

PlentyONE property

This drop-down list contains the categories that you have set up in PlentyONE. Select the appropriate property from the drop-down list.

Requirement: Have you already configured properties in PlentyONE? This drop-down list only includes the properties that already exist in PlentyONE.

SPoCC attribute

This drop-down list contains your SPoCC attributes. Select the appropriate attribute from the drop-down list.

Adds another line. This allows you to map additional properties.

Deletes a line. This allows you to remove mappings that are no longer needed.

4.5. Step "Categories"

In this step, you map the product groups used in SPoCC to the categories in PlentyONE. This way, your items are directly sorted into the correct PlentyONE categories when they are imported from SPoCC.

Important: Items in SPoCC categories that you did not map in this step will be sorted into a default category. This default category is the one you select in the step Options for the item import.

Table 6. Mapping of categories
Setting Explanation

SPoCC product group

These are your product groups in SPoCC. Select the appropriate product group from the drop-down list.

PlentyONE category

These are the categories that you’ve set up in PlentyONE. Select the appropriate category from the drop-down list.

Requirement: Have you already created categories in PlentyONE? This drop-down list only includes the categories that already exist in PlentyONE.

Adds another line. This allows you to map multiple categories.

Deletes a line. This allows you to remove mappings that are no longer needed.
Alternative procedure without assigning categories

Technically speaking, you could just select a default category in the step "Item import" and then skip the rest of the category assignment. As a result, your items would always land in the default category when they are imported. If needed, you would then have to move the items into different PlentyONE categories manually.

4.6. Step "Warehouse"

In this step, you map your Channel Store Number from SPoCC to your PlentyONE warehouses.

Table 7. Mapping warehouses
Setting Explanation

SPoCC Channel Store Number

These are your warehouses in SPoCC. Select the appropriate Channel Store Number from the drop-down list.

PlentyONE warehouse

These are your warehouses in the PlentyONE menu Setup » Stock » Warehouse.

Adds another line. This allows you to map multiple warehouses.

Deletes a line. This allows you to remove mappings that are no longer needed.

4.7. Step "Markets"

Table 8. Mapping markets
Setting Explanation

PlentyONE referrers

The drop-down list contains your markets in PlentyONE. Select a character set from the drop-down list.

SPoCC referrers

The drop-down list contains your markets in SPoCC. Select the same market from the drop-down list.

Adds another line. This allows you to map multiple markets.

Deletes a line. This allows you to remove markets that are no longer needed.

4.8. Step "Return reasons"

Table 9. Mapping return reasons
Setting Explanation

PlentyONE return reasons

The drop-down list contains your return reasons in PlentyONE. Select a return reason from the drop-down list.

Important: SPoCC always expects that a return reason is given. If you have not mapped a SPoCC return reason for a PlentyONE return reason, the return reason [1] No reason is exported to SPoCC.

SPoCC reasons for return

The drop-down list contains your return reasons in SPoCC. From the drop-down list, select a return reason that corresponds to the reason you selected in the column PlentyONE return reason.

Adds another line. This allows you to map multiple return reasons.

Deletes a line. This allows you to remove return reasons that are no longer needed.

4.9. Step "Processes"

Data is transmitted between SPoCC and PlentyONE with the help of Crons.

What is a cron?

A cron is used to run processes based on a schedule. These are run in individual cron jobs.

So cron jobs are recurring tasks (jobs) that start automatically in set intervals. These intervals are usually specified in minutes. So for example, a "cron 60" runs every 60 minutes.

Example: Item data is exported to a market once per day. To do that, a "cron 1440" is used. Each export is its own cron job.

Fun fact: Cron stands for "Command Run On Notice". However, the term also alludes to Chronos, the Greek god of time.

Why you need to know what a cron is? Well, actually you don’t need to know that at all. All you do is activate the data exchange in PlentyONE. The rest happens automatically. Awesome, right?

In this step, you’ll activate the processes that should run automatically ().

Table 10. When do the processes run?
Process Interval Explanation

Import of SPoCC attributes

Hourly

Imports the SPoCC attributes to PlentyONE.

Item import

Daily

  • Once you have completed the assistant, all of your items will initially be transmitted from SPoCC to PlentyONE. This initial, full import can take a few days to finish, depending on the number of products.

  • Afterwards, only a sub-set of items will be imported, based on the previously selected import settings.

  • Only new items, new variations of existing items and changed items and variations are imported.

  • The item import starts at the end of the day, or rather during the night.

Import of extended item data

???

Imports EAN, images and properties for variations that are flagged with the tag you selected for the setting Tag for importing extended item data.

Import of images

Every 60 minutes

Imports SPoCC images to PlentyONE.

Complete stock/price update

Once every 24 hours

All stock and price data is updated.

Update changed stock and price data

Every 15 minutes

Only changed stock and price data is updated.

5. Opening and modifying newly imported item data

The next time the process runs, your item data will be imported from SPoCC to PlentyONE. This assumes that you’ve:

  • activated the Item import process ().

  • completed the assistant.

  • activated the plugin within the set.

5.1. Opening newly imported items

Open a few item data records and make sure that your item data was correctly imported.

  1. Go to Item » Edit item.

  2. Use the search filters on the left to specify which items you want to access. For example:

    1. Set the Active filter to ALL or No, since items are inactive when they are imported.

  3. Click on Search ().
    → The search results are displayed in an overview on the right.

  4. Click on an item in the overview to open the item data record.

Main variation vs. Sub-variation

Check the data that was transmitted for the main variation and for the sub-variations:

  • Main variation: An item’s first variation is called its main variation. It is not for sale, but rather is purely virtual and helps you manage the sub-variations via inheritance. When you open an item data record, the main variation automatically opens too.

  • Sub-variation: The sub-variations are the saleable versions of the product. For example, if a t-shirt is sold in the colours blue and red and the sizes S, M, L, then every single combination (Blue S, Blue M, Blue L, Red S, Red M, Red L) is a sub-variation. To open a sub-variation, click on the tab Variations and then on Search (). Finally, click on a sub-variation in the overview.

5.2. Modifying item data

Once you’re happy with the item data that was transmitted, you can start preparing your items to be sold online. For example, you can:

  • add descriptive texts, product images and relevant meta data.

  • specify where your products should be sold, i.e. select order referrers and clients.

  • Activate your variations when you are ready for them to go live.

For a complete list of all the item data fields in PlentyONE. refer to the page Directory of data fields.

6. Processing orders

When a product is sold, the order data lands in the PlentyONE menu Orders » Orders. The order can be processed here and its progress can be tracked with the help of a status.

Further information about processing orders in PlentyONE can be found on the Orders page of the manual.

7. Setting up event procedures

Of course, the order data shouldn’t just stay in PlentyONE. Rather, it should also be transmitted to SPoCC. You will set up event procedures to do this. These event procedures only need to be set up once, in order for the export to work correctly.

The following event procedures are available for SPOCC:

For further information, refer to the Event procedures page of the manual.

7.1. Notifying SPoCC of new orders

When a new order lands in PlentyONE. SPoCC should be informed of the order. This allows SPoCC to reserve the necessary stock and avoid overselling.

Set up an event procedure for that purpose.

Setting up an event procedure

  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to [table-event-procedure-one].

  5. Save () the settings.

  6. Carry out the additional settings according to [table-event-procedure-one].

  7. Select the setting Active ().

  8. Save () the settings.

Event

New order

Filter (optional)

Order > Referrer
Order > Client (store)

Action

Plugins > SPoCCConnector: Register order
→ An order with the SPoCC status ID is created in SPoCC.
→ The stock is reserved in SPoCC.

7.2. Inform SPoCC about payments

SPoCC is to be informed when the order is paid. Only then, the order becomes accessible for the SPoCC shop and the order can be processed by the warehouse.

Set up an event procedure for that purpose.

Setting up an event procedure

  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to [table-event-procedure-8993901978].

  5. Save () the settings.

  6. Carry out the additional settings according to [table-event-procedure-8993901978].

  7. Select the setting Active ().

  8. Save () the settings.

Event

Status change > [Select status that is to be set when event is triggered]

Filter (optional)

Order > Referrer
Order > Client (store)

Action

Plugins > SPoCCConnector: Order paid
→ The order is moved to the SPoCC status ??? in SPoCC.
→ The order becomes accessible for the SPoCC shop and can be processed by the warehouse.

7.3. Inform SPoCC about the creation of order documents

Automatically inform SPOCC that shipping documents have been created. This informs the store that the order can be shipped.

Set up an event procedure for that purpose.

Setting up an event procedure

  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to [table-event-procedure-0414974358].

  5. Save () the settings.

  6. Carry out the additional settings according to [table-event-procedure-0414974358].

  7. Select the setting Active ().

  8. Save () the settings.

Event

Status change > [Select status that is to be set when event is triggered]
Example: Status change > [5] Cleared for shipping

Filter (optional)

Order > Referrer
Order > Client (store)

Action

Plugins > SPoCCConnector: Shipping documents created
→ Order documents are exported to SPoCC.

7.4. Inform SPoCC about returns

Automatically inform SPoCC that a variation is to be returned. The store knows that a return is on its way.

Set up an event procedure for that purpose.

Setting up an event procedure

  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to [table-event-procedure-1052999368].

  5. Save () the settings.

  6. Carry out the additional settings according to [table-event-procedure-1052999368].

  7. Select the setting Active ().

  8. Save () the settings.

Event

Status change > [Select status that is to be set when event is triggered]

Filter (optional)

Order > Referrer
Order > Client (store)

Action

Plugins > SPoCCConnector: Register return
→ The order is moved to the SPoCC status ID 18 in SPoCC.
→ The return reason is exported. If you have not mapped a SPoCC return reason for a PlentyONE return reason, the return reason [1] No reason is exported to SPoCC.

7.5. Processing orders after shipping confirmation

Select what happens to orders after SPoCC has confirmed shipping.

Set up an event procedure for that purpose.

Setting up an event procedure

  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to [table-event-procedure-UI7TSJAK].

  5. Save () the settings.

  6. Carry out the additional settings according to [table-event-procedure-UI7TSJAK].

  7. Select the setting Active ().

  8. Save () the settings.

Event

SpoccConnector

Order shipped

Filter (optional)

Order > Referrer
Order > Client (store)

Action

7.6. Processing orders not registered with SPOCC

Select what happens to orders that could not be registered with SpoCC. These are new orders for which the procedure SPoCCConnector: Register order could not be triggered.

Set up an event procedure for that purpose.

Setting up an event procedure

  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to [table-event-procedure-VOQ82RU7].

  5. Save () the settings.

  6. Carry out the additional settings according to [table-event-procedure-VOQ82RU7].

  7. Select the setting Active ().

  8. Save () the settings.

Event

SpoccConnector

Registration failed

Filter (optional)

Order > Referrer
Order > Client (store)

Action

7.7. Processing orders after a cancellation request

Select what happens to orders that were cancelled in SPoCC.

Set up an event procedure for that purpose.

Setting up an event procedure

  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to [table-event-procedure-KZ1UJ2CB].

  5. Save () the settings.

  6. Carry out the additional settings according to [table-event-procedure-KZ1UJ2CB].

  7. Select the setting Active ().

  8. Save () the settings.

Event

SpoccConnector

Cancellation requested

Filter (optional)

Order > Referrer
Order > Client (store)

Action