Importing Orders & Stock Control

[Marci]

Quicky - should importing orders then adjust stock counts??

(Two separate PCs, one handling orders, one handling maintenance)

[los_design]

Quicky - should importing orders then adjust stock counts??

(Two separate PCs, one handling orders, one handling maintenance)

Not sure if it does, but it should...

Regards

[Marci]

That's what I thought - it appears it doesn't...

[los_design]

That's what I thought - it appears it doesn't...

Hi Marci

I will have a wrestle with this later and see if we can kick start it

(our excel guru may be able to pick some bones out of it and see if we can spot a trigger...unless Act Dev know something?)

[Jan]

What you should do is build a linking table between the two that contains a stock level table, this can be linked using External linking to link the stock levels on the two machines.

Regards,

[Marci]

We used to run like this for Act 3 (I think!) thru 6 (I posted the instructions on here on how to do it way back when as everyone else was asking the same question), but it stopped working with v6...

Gizza clue please Jan - which table for v8, and in which direction?? IE: data-bearing table on maintenance pc, or data-bearing table on orders pc?

[Jan]

The table is the product table, so just export that to it's own database and then switch on external linking in each of your sites (put the new database on a shared drive) and the link the stock level fields to the external database.

Regards,

[Marci]

Perfect sense - thanks muchly!!

[Marci]

Implemented - appears to be working - word of wisdom for anyone else attempting this...

Once you've linked the Products table, if you go to your orderprocessing PC and look at the content, it'll look rather whacky, and may not show the correct sections tree. If this is the case, repeat the above instructions for the "Catalog section" table also, so that the database on the shared drive to which both PCs are linking contains TWO tables, "Products" and "Catalog section" - then the structure will look correct on both PCs.

Visually (in the preview pane) they will be very different unless you duplicate all your style/theme files & images over onto the Orders PC also. In such a case, just ensure no-one hits the upload button on the orders PC!