Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
Connect Magento to MS Access Database?
Scott Sladick
California

Excellent
May 7, 2014 - 11:58 pm
Member Since: April 25, 2014
Forum Posts: 66
sp_UserOfflineSmall Offline

Hey there,

Any idea on connecting Magento to a MS Access database to keep the stock levels the same throughout? I’d like to ditch Access altogether, but our supplier in China uses it to update our shipments.

I have thought of using ODBC but this won’t work because I will have to do mapping on the database fields to get the data in the right place.

Any ideas would be greatly appreciated.

Thanks!

Richard Meldner
Miami/Ft. Lauderdale Area
Member
May 8, 2014 - 12:29 am
Member Since: May 3, 2014
Forum Posts: 325
sp_UserOfflineSmall Offline

I really can’t envision any way to connect two different databases with different fields without some kind of mapping or cloning one database into the other.

Maybe you can find a tool with these companies that can help:
http://dbconvert.com/
http://www.devart.com/

Richard

You have to start with a plan to know what you will be deviating from.

Managing Petty Tyrant: mdiperformance.com

Avatar
Matthew Ogborne

Founder
May 8, 2014 - 10:35 am
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Howdy Scott,

I’ve not touched Access for years, however in theory this is possible and there are multiple routes.

The one thing you need, is to make sure that the stock number between the two systems match, if you have this, happy & days!

Here are a couple of ideas:

1. Use the Magento API http://www.magentocommerce.com…..ntory.html to grab the stock levels remotely
2. Set up a scheduled export using a dataflow profile to export sku and qty (if exporting
3. The reverse of the above as an import
4. Scripting Magmi to import the sku and qty columns in PHP
5. Manually exporting and importing

Loots of options, the main challenge will be getting the data and automating the process as much as you can.

Hope that gives you a few ideas,

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

Scott Sladick
California

Excellent
May 8, 2014 - 7:18 pm
Member Since: April 25, 2014
Forum Posts: 66
sp_UserOfflineSmall Offline

Thanks Richard for the links, unfortunate it doesn’t seem like those programs are going to do what I need due to the mapping issue.

Matthew, I will look into those methods, but as you said they do seem to still require manually updating in some way.

I was thinking of creating a custom XML feed out of Magento with just the SKU and Quantity, then have an ASP file on my server parse the XML and throw it in the access db.

I can code the scripts myself, but if there is a built in feature to create custom xml feeds in Magento that would be much easier. Is there such a thing or an extension?

Avatar
Matthew Ogborne

Founder
May 8, 2014 - 8:18 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi Scott,

See the dataflow export profiles in System > Tools > Dataflow profiles.

You can create CSV and XML using this and these profiles can be cron’ed to create the files for you.

See here for a script that will do that for you too.

http://www.magentocommerce.com…..0/#t277875

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

Scott Sladick
California

Excellent
May 8, 2014 - 9:32 pm
Member Since: April 25, 2014
Forum Posts: 66
sp_UserOfflineSmall Offline

Matthew Ogborne said

Hi Scott,

See the dataflow export profiles in System > Tools > Dataflow profiles.

You can create CSV and XML using this and these profiles can be cron’ed to create the files for you.

See here for a script that will do that for you too.

http://www.magentocommerce.com…..0/#t277875

Matt

Perfect! Thank you very much!!

Avatar
Matthew Ogborne

Founder
May 10, 2014 - 12:05 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Howdy Scott,

Superb, it’s one of the advanced tutorials we’d like to get added in as this can be abused to create export files for external systems, such as Amazon repricers.

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

 

Why Should You Join UnderstandingE?

 
  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks

 

Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
21 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5221

Posts: 27486

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606