Knowledge Base

Gordon & Gotch Supplier Stock Code Length Change

Last Updated at

As you may be aware, Gordon and Gotch (GG) have decided to change the length of their supplier stock codes from 5 digits long to 10 digits long. 

The reason for this change is that GG have almost exhausted the 5-digit codes. To facilitate the addition and distribution of new stock, this needed to be extended. Existing 5-digit codes will have an 10000 added to the beginning of the code. 
For example, the supplier code for NEW IDEA will change from 12781 to 1000012781 (plus a 3 to 6 digit issue code).

The change to 10-digit codes will occur on Tuesday 13th February 2018. This means that all Invoice, Sales and Returns files sent to or received by XchangeIT will require and expect the new 10-digit codes. 

To help with this, the team here at Tower Systems have developed a utility that will change all your existing codes, in bulk, to the new 10-digit length. The utility will not only update your GG stock items with the new 10-digit codes to allow XchangeIT invoices to be imported correctly but will also change your historical data so that sales files and return data are compliant.

Only run the utility once you have completed your magazines arrivals for Monday the 12th of February and ensure it has been performed before 10am on Wednesday the 14th of February. 

Please Note:This utility is linked to your Tower Advantage Account and can only be run once per store.  

Prior to Running the Utility

If you do not use XchangeIT and you arrive Gordon and Gotch magazines manually, please follow the steps below, prior to running the utility:

  1. From the main screen of Retailer, Click on Stock > Invoice arrivals
  2. Click on EDI at the top right.
  3. Click Close then Close.
  4. From the main screen of Retailer, click on Stock -> Suppliers and Departments.
    Alternatively, on the top menu bar of Retailer, click on Stock Maintenance -> Suppliers and Departments.
  5. Click on the Suppliers tab.
  6. Click on the magnifying glass icon and search for your Gordon & Gotch supplier.
  7. Click on the EDI tab.
  8. In EDI Abbreviation, ensure that it is set to GG. (CASE SENSITIVE)
  9. Click on Save, if needed, and then Close.

Downloading and Running the Utility

  1. On the Main computer.
  2. Right-click HERE and select Save As / Save Link As / Save Target As.
  3. On the left panel, click on Desktop.
  4. Click Save.
  5. Minimize all your windows to return to the Desktop.
  6. Double-click on the SCGGUpdate.exe file.
    NOTE: If you get an AVG pop up blocking the file. Disable AVG and then run the file again.
  7. Click on Run
    1.PNG
  8. Click Next
    Please Note: This utility is linked to your Tower Advantage Account and can only be run once per store.
    2.PNG
  9. Enter you Tower Advantage username and password. Then click Next
  10. NOTE: This is the same login for the Tower WebsiteIf you don't know your password you can reset the password HERE, or by clicking the 'Forgot Your Password' link on the sign-in page of the Tower Systems website.
  11. Then, click Install
    3.PNG
  12. Click Finish.
  13. A black screen will appear and the utility will run.
    It may take a couple of minutes to complete. DO NOT CLOSE THIS WINDOW
    Once the black screen disappears, the process is complete.

Post Utility Checks

  1. On the main screen of Retailer, click on Stock -> Stock Screen.
    Alternatively, on the top menu bar of Retailer, click on Stock Maintenance -> Stock Screen.
  2. Click on the magnifying glass icon and search for the NEW IDEA parent item.
    This will normally have the PLU of NI or similar.
  3. Check that the Supplier Stock Code has 10000 added to the front.  For example depending on your location your New Idea code could be now 1000012781 (plus a 3 to 6 digit issue code). 
  4. Click on Close.
  5. Back on the main screen of Retailer, click on Stock -> Suppliers and Departments.
    Alternatively, on the top menu bar of Retailer, click on Stock Maintenance -> Suppliers and Departments.
  6. Click on the Suppliers tab.
  7. Click on the magnifying glass icon and search for your Gordon & Gotch supplier.
  8. Click on the Newsagency tab.
  9. Ensure that:
    • Full Supplier Stock Code Length is 17
      AND
    • Supplier Stock Code Length (without the Issue Code) is 10.

If either step 3 or step 9 are not the case, please contact Tower Systems Support for assistance.

Was this article helpful?
14 out of 14 found this helpful

Comments

  • Avatar
    EDM4869

    Where is it??

  • Avatar
    Tower Support

    As we have mentioned in all communication the utility will be available mid monring. You will be notified by email.

  • Avatar
    GAT4343

    Thanks.

  • Avatar
    NEW4508

    I'm assuming we run it after we finish business for the day

  • Avatar
    SUP4000

    We received an invoice on Friday that is actually for mags that are coming in on Thursday the 15th. Do you suggest arriving that invoice prior to running the utility or do we arrive it after. We have arrived everything that was meant for today.
    Also, can we scan out our returns as per normal for mags today or should we scan them out after running the utility. Thanks

  • Avatar
    Tower Support

    They should be arrived like you would normally on Wednesday arvo/Thursday. You do not need to change the return processes the utility will update them in preparation for the RTF on wednesday.

  • Avatar
    Tower Support

    No. Only Run it during business hours.

  • Avatar
    OXF4171

    The Supplier Stock Code for New Idea shows 10000127818880. Is that ok

  • Avatar
    Tower Support

    Yes. the first 10 are the supplier code the additional numbers are the issue code.

  • Avatar
    NXP4810

    Hi Guys
    we are in FNQ queensland and the stock code I am getting is 100000136478880 is this ok as New Idea FNQ is what we have in stock code file

    Edited by NXP4810
  • Avatar
    Tower Support

    yes the canbe can be different depending on your location. as long as it has the 10000 at the start its ok.

  • Avatar
    NXP4810

    thank you

  • Avatar
    CUR4223

    Is this only done one the Main computer

  • Avatar
    NEW4567

    Thanks TOWER Peeps, very easy, clear instructions - All good!

  • Avatar
    Tower Support

    No Worries. Been a hectic day here as you can imagine!

  • Avatar
    ARD5571

    Thanks Tower support team! Eazy Peazy :)

  • Avatar
    INJ4454

    Thanks Tower very easy

  • Avatar
    YAR3677

    being told gg utility is not active for this account.. help

  • Avatar
    SUR4507

    Thanks Tower you made it so easy

  • Avatar
    208193

    Thanks for the support guys

Follow
We're here to help
Powered by Zendesk