Post by btracy » Sat Mar 12, 2011 7:43 am

I am working on/need help with a project.

I want my client to be able to edit an excel sheet or a UI and have that remotely sync every so often so that the product line is up to date.

I want this because my client owns a store and also sells online. But she has a limited inventory and does not have UPC's to keep track on in store inventory to be able to sync both store and online store. So basically she has to enter the inventory amount manually. So I would like to make it simple for her to be able to simply enter the product inventory on her computer and have it simply sync with the admin site. Tell me what you think of this idea and if it is feasible.

I will have updates occasianaly if anyone is interested.

The site that I'm doing this for right now is: http://www.chelseasboutiqueonline.com

Newbie

Posts

Joined
Sun Jan 30, 2011 10:20 am

Post by justinv » Sun Mar 13, 2011 11:34 am

It's feasible. You would need to set up some sort of interface on your shop by which it would accept updates, and you would need to have a script running on her computer to regularly read the spreadsheet and send it to the interface you set up.

It would be easier to use one of the existing import tools and manually import the spreadsheet periodically, if programming resources aren't already available.

Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
Image


Active Member

Posts

Joined
Tue Oct 12, 2010 1:24 pm

Post by i2Paq » Sun Mar 13, 2011 3:40 pm

Actually there are 3 options that offer more or less what you are looking for:

Most used: Export/Import tool for OpenCart 1.4.9.

Option 2: [MOD] Apsona ShopAdmin - import, export and reporting.

Option 3: OpenCart Tool.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by btracy » Mon Mar 14, 2011 6:14 am

Ok, wow those are great options. I guess the best would be option 3 but it seems that the site is not working properly for a download. But I really appreciate the input. I should have been more diligent in my research of the topic, would have saved myself alot of time and effort. Again, thanks alot!

Newbie

Posts

Joined
Sun Jan 30, 2011 10:20 am
Who is online

Users browsing this forum: No registered users and 138 guests