Announcement

Collapse
No announcement yet.

EPOS Stock Levels in Database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    EPOS Stock Levels in Database

    Hi
    We are installing a Data Server (in readiness to go live with Oxatis Plugin for our new Actinic Online Website) which will capture stock levels from all our channels. Which will be done through linked tables.

    We have tested the EPOS links, and these are all working fine, but we cannot find the table in the EPOS Db which reports the actual stock. Does anyone know where is it.

    We ran a few tests yersterday to ensure we have the right table, but when we ran a sanity check the: -
    Db reported for example: Stock Available 1, (Data/tblProduct: Stock Level)
    EPOS Product lookup said Instock 2.
    We checked the actual stock and there was 2.
    This happened on several lines of data.

    Does anyone know where or which tables hold the stock level data that EPOS reports correctly or what tables are used to calculate the Stock Level reported by EPOS?

    Many thanks
    Andrew

    #2
    Hello Andrew

    The tables are - tblProduct.StockLevel and tblProduct.Stock_Allocated. Please ensure to take a backup before proceeding. Hope this helps.

    Regards
    Krithika Chandrasekar
    SellerDeck

    sigpic

    E-commerce software by SellerDeck

    Comment

    Working...
    X