Tech Home The Bacon

Technology Blog

Tag: sage 100

Sage 100 & Shopify – Inventory Updates

This is a brief nontechnical overview for anyone wanting to know how I push our Sage inventory to one of our Shopify stores. 

In the above image, we start with our on-premise Sage 100 and create a visual integrator (vi) job that exports out the SKUs, quantity available to ship, and retail pricing in a CSV format. 

The vi job exports the CSV file to our internal FTP server that is automated to send the file at certain times to our public web server.

The web server just holds the file for a 3rd party Shopify app called Syncee to pick up and import into our Shopify store. 

Syncee provides email notifications after each job has finished. This email contains details on how many products were updated and how many errors each job encountered. 

Syncee is not a free app by no means, but it worth every penny from my perspective. Syncee plans are based on how many products you want to update and how many times a day you want to run the job.

The devs/support staff are great when you have problems and they will help you get things mapped out before you automate the jobs. After the job is scheduled there really isn’t much to it after that, just make sure you monitor your job status via the email notifications. 

Windows Server 2016 RDS Problems with Sage 100 2017 RemoteApp

sage 100 remoteapp problem windows not appearingRemoteApp Problems – Windows Not Showing:

We deployed a new RDS server this week with Sage 100 2017 published as a RemoteApp. One of our remote sites called in and said it was taking an unusual amount of time for the windows to open. I remoted into their machine and walked through some normal operations of creating a sales order. The window to select a customer account seemed to be taking a long time to appear, but when I hovered over the icon in the taskbar it was showing the new window was already running. If you click on the area where the new window was supposed to be it would appear. The windows of the RemoteApp were not drawing to the screen. To the user, the window wasn’t appearing at all, but when the user got frustrated they would start clicking randomly and the window would finally appear.

Continue reading

© 2018 Tech Home The Bacon

Theme by Anders NorenUp ↑