GNC - Order Automation

GNC - Order Automation

Header and Detail Flat Txt Files and PDF get FTP'd to us.
Header Flat File (contains "hd")
Detail Flat File (contains "dt")
PDF

NOTE: The file names begin with the last 3 digits of the wave name... IE if Dody asks about "wave  15662", the files start with 662...

Task Scheduler runs "GNCUpload" every 30 minutes.
This runs \\Web2\e$\EDInterchange2022\GNCUpload.bat
This runs:
OrderImporter.exe /p:1
OrderImporter.exe /p:2
cmdUtil.exe /o:w /p:5

Orders are added to WinSQL2 DB ImportOrder Table

After Processing an email goes to Dody and to us.

PDF File gets moved to:
\\Web2\e$\EDInterchange2022\Files\GNC\PDF

Files get moved to:
\\Web2\e$\EDInterchange2022\Files\GNC\Orders

Ship Notes are sent daily (early morning) via email.

Usually if there is a problem it is because the files never made it to our sFTP.
Simply check the sFTP to see if the files are there, if not they need to resend.
Sometimes they send the order files but not the PDF workorders.
Sometimes an orders in the Header File does not have a matching number in the Detail file. This causes an error. The offending order could be removed from the header file to proceed. That order would then need to be manually input by Dody using the work order as a guide.

    • Related Articles

    • CIMPRESS - Integration Automation/Process/Status

      CIMPRESS - Integration Order Automation 2.0 S.O.P. Version 3.0 10/18/2024 OBJECTIVE The following guide is used to understand the inner workings of our Cimpress integration. DEFINITIONS CIMPRESS WEB SERVICE = We created and maintain a custom Web ...

    • 🛠 How to Correct WIP Inventory and Adjust Sales Orders in Impress

      Overview Sales orders that are already in production or WIP (Work in Progress) must follow a strict process when corrections or cancellations are needed. This guide outlines the correct sequence for reversing sales order activity and updating ...

    • SOURCED GOODS UNPACKING WAREHOUSE S.O.P

      OVERVIEW Sourced Goods pieces are purchased by the inventory team daily using the PO Builder screens in Impress. Packages for Sourced Goods orders arrive with a special Vantage PO number, for example “P123456-S12345”. Where the P number represents ...

    • Sourced Goods unpacking process in VAT

      OVERVIEW Sourced Goods pieces are purchased by the inventory team daily using the PO Builder screens in Impress. Packages for Sourced Goods orders arrive with a special Vantage PO number, for example “P123456-S12345”. Where the P number represents ...

    • CIMPRESS - CSR

      CIMPRESS - CSR Sales Order/Art 1.0 S.O.P. Version 1.0 10/21/2024 OBJECTIVE The following guide is used to understand how Cimpress Sales Orders are to be processed, how art is obtained and setup, and how to troubleshoot orders. OVERVIEW We created a ...