Stocks Download

The task fetches nothing from TriData but the stock. It is separate from Products Download, because stock changes hourly and an article rarely does: a change in stock should not push the whole product record down the chain. It accordingly runs more often.

What gets transferred

The stock rows for the article and for the color and size combination, each onto a store in TRADElube. The task finds a product through its channel mapping, and where that is still missing, through the product number.

TriCon delivers several quantities side by side per stock row, and you decide which of them is your stock: quantity available and stock on hand, each in total and for the local branch, plus ordered and reserved quantities. The difference is no subtlety. Stock on hand is what stands on the shelf, the available quantity subtracts reservations, and only the second is what you can offer in the shop.

How the transfer plan is built

One plan with five sections.

Section What sits in it
Selection Which stock rows are taken over, and how the product for them is recognized
Common The product number a missing product would be created under
Combinations The same for the color and size combination
Stock The quantity proper, one tab per store of your client
Additional Properties A number out of TriData into a property on the product instead of into the stock

The Stock section is the one the task exists for. Per store you pick one of TriData's quantities, and the choice applies per tab: one store can take the total available quantity and a second the local branch's.

The two sections Common and Combinations are unticked out of the box, and rightly so. They create a product that does not exist yet, and that belongs to Products Download. They are only needed where you want to keep stock for articles that never went through the product import. The designation of a product created that way is then a dash.

Additional Properties accepts only properties of the type text, number and integer, because a selection property would have no fitting value for a quantity.

Special features and limits

A diverging product number aborts the row. TriCon keeps the product number in two places, on the article and on the stock, and a full upload covering only the articles lets the two drift apart. TRADElube reports that per record rather than silently changing the mapping. A product hangs off its identifier and not off its number. The way back is under Unterschiedliche Produktnummern.

Stock is the one area TriCon updates by itself, provided it is set up accordingly. That only holds for articles already present in TriCon whose product number has not changed.

Further reading