Post by Saulevas » Thu Dec 10, 2015 1:09 am

Hi everyone.

So, our company manages three e-shops selling clothes. All our stock is controlled via Google Sheets so each manager can see what the other manager has sold, what quantity of particular product is left etc. I thought that it would be great if we could sync Google Sheets to our Opencart 2 e-stores, so when the client selects a product he could see live stock of that product. The stock would be synced to information entered in Google Sheets.

Do you think it could be possible?

New member

Posts

Joined
Wed Jan 08, 2014 3:36 am

Post by VictorDrummond » Thu Dec 10, 2015 10:28 pm

Saulevas wrote:......... so each manager can see what the other manager has sold, you can what quantity of particular product is left etc. I thought that it would be great if we could sync Google Sheets to our Opencart 2 e-stores, so when the client selects a product he could see live stock of that product. The stock would be synced to information entered in Google Sheets. Do you think it could be possible?
I'm just going to throw a little something at ya...
Maybe merely just some food for thought...

I've gone the other way for my company...

Shoot sales numbers directly from Oc into Xero cloud accounting software via cron-job, and any of your managers would be able to integrate with Xero from their own separate login and individual level of access to Xero, including inventory numbers updated by the invoices created in Xero by Opencart...

Even create different sales or expense account tracking channels within company's chart of accounts for more in-depth analysis, for let's say, different stores, income streams, etc, all pretty much fully automated, excepting perhaps, invoice final approval from draft status... Is awesome accounting software, includes payroll that can be formulated and set up for any tax jurisdiction on the planet... All rolled into one package, even multi-currency with live api payment gateway feeds for easy bank statement reconciliation... The list of advantages goes on...

The module to do this is easily available, this is the one I use, and these guys are awesome to deal with taboot: http://www.opencart.com/index.php?route ... earch=xero

Hosting for Oc 2.x: Well tested on 2.03.1 including emails work correctly, cPanel Shared or WHM VPS, managed security, fast & reliable SSD drives, Raid 10 /4 disk redundancy, server locale - Texas, contact me to discuss further.


User avatar
Active Member

Posts

Joined
Sat Dec 15, 2012 12:41 pm
Location - On the balcony slammin' Margaritas
Who is online

Users browsing this forum: No registered users and 4 guests