Guest Posted July 12, 2005 Share Posted July 12, 2005 Okay i just started upgrading my site to osCommerce. the previous setup i had was only the simple paypal add to cart buttons... i see oscommerce is very full featured, but im afraid that it might add more work on my part. My old procedure was: 1. customer places an order 2. i sign into my paypal account 3. i click on each order and copy and paste the fields needed into my Access database (most time consuming) 4. from there i open up my "Pending orders" Query and check off the orders that I am going to ship out today. 5. I then copy and paste the name and address fields into the stamps.com application. 6. I print and I start packaging.. What I'm trying to achieve right now is eliminate the nonsense copy and paste procedure that I've been doing for the past year. I want to be able to open up my access database and select the ones i will be shipping out today and have stamps.com just print it all out at once instead of doing it one at a time.. has anyone achieved this process? I'm trying to make this as automated as possible... -thx :thumbsup: Link to comment Share on other sites More sharing options...
wizardsandwars Posted July 13, 2005 Share Posted July 13, 2005 well, personally, if I *had* to use an MS Access database <shudder>, I would download an install the MySQL ODBC drive, myODBC, so that you could connect directly to your osC database, and run a stored procedure to download all your orders. Also, I think the stamps.com application will accept an external csv file that you could create with your MS Access. you could also *update* your osC database through your access application to give your shipped orders an appropriate status (like 'shipped' or something). Anyways, it seems like alot of moving parts, but if you use the MySQL odbc connection, you can probably do quite a bit of that with MS Access. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 well, personally, if I *had* to use an MS Access database <shudder>, I would download an install the MySQL ODBC drive, myODBC, so that you could connect directly to your osC database, and run a stored procedure to download all your orders. Also, I think the stamps.com application will accept an external csv file that you could create with your MS Access. you could also *update* your osC database through your access application to give your shipped orders an appropriate status (like 'shipped' or something). Anyways, it seems like alot of moving parts, but if you use the MySQL odbc connection, you can probably do quite a bit of that with MS Access. <{POST_SNAPBACK}> thx for your help... so what you mean is that i should shy away from using access and migrate to MySQL odbc drive (not sure what that is exactly)? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.