OXID Community Forum

> International Forums > Installation and configuration > Oxarticles table update
Login
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Thread: Oxarticles table update


Reply
 
Thread Tools Display Modes
#Top   #1  
Old 03-24-2012, 12:00 PM
Harko Harko is offline
Junior Member
Join Date: Feb 2011
Posts: 12
Harko is on a distinguished road
Default Oxarticles table update

Hello all,

I need to set up a shop and the main requirement is to make this small shop owner possiblility to update oxarticles table especialy the field oxstock via xls or csv import but there is but. Let me explain.
I can do this update easily if i first export the oxarticles tables either straight from databse or from admin meniu and change values there but the customer wants to export the products from his erp system with the present stockqty ant then from that file import to exshop the exact qty. He is not going to sell from the online shop only the stock managem,ent will be activated. The online shop is only for seeing detailed products with qty making an order and sendind that order to shop owner for maybe further actions. What is the best procedure for me to start? When i do the bulk import i know that this procedure looks at oxid and if it finds oxid in tte database it rewrites the data but if oxid is different it makes a new record.
Is it so that in oxarticles i have to manualy adjust oxid to the same id in customers erp system of product id . In this case id are the same but this gives some troubles in oxseo and other tales.
Or i'm thinking to make the oxartum the same as some art in customers erp and first to export data from erp, then export data from oxarticles, and make a small script in excel or access by joining oxarnum and someart from customers erp. Maybe someone can advice the right procedure? How to make it simple to export from erp and import to oxshop?
Reply With Quote
#Top   #2  
Old 03-24-2012, 12:04 PM
Marco Steinhaeuser's Avatar
Marco Steinhaeuser Marco Steinhaeuser is online now
Community Guide @ OXID
Join Date: Oct 2008
Posts: 10,865
Marco Steinhaeuser is on a distinguished road
Default Re: Oxarticles table update

Hello Harko,

well, I think the best would be to have a real interface OXID <-> ERP system so you can synchronize all data without any hassle of generating xls or csv files. Which ERP does your client use?

Regards
__________________
Marco
http://about.me/marco.steinhaeuser

Will ignore unsolicited support requests via PM, email or IM.
Reply With Quote
#Top   #3  
Old 03-24-2012, 12:09 PM
Harko Harko is offline
Junior Member
Join Date: Feb 2011
Posts: 12
Harko is on a distinguished road
Default Re: Oxarticles table update

Quote:
Originally Posted by Marco Steinhaeuser View Post
Hello Harko,

well, I think the best would be to have a real interface OXID <-> ERP system so you can synchronize all data without any hassle of generating xls or csv files. Which ERP does your client use?

Regards
Well this is an old erp from scratch. This is not like axapta or navision I know this is the best way of real time synchronization but as usual customes want to save some money so at this time maybe this way is better? Or you would suggest and easy way to make OXID-<>ERP?

Regards
Harko
Reply With Quote
Reply

Bookmarks

Tags
oxarticles, table, update

« Previous Thread | Next Thread »
Thread Tools
Display Modes

Nicht Sichtbar
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add field to oxarticles table spierala Newbies 4 10-23-2012 08:50 AM
Zugriff oxarticles.php u. oxprice.php auf DB-Table floko Entwickler 3 09-27-2011 10:31 AM
New Class for a new table ahtasham82 Developers 3 04-07-2011 11:44 AM
oxarticles.OXTIMESTAMP wird bei article update nicht aktualisiert? Binary Entwickler 1 02-05-2010 06:55 AM
SQL-Befehl für Update der oxarticles gesucht kinderlampenland Module 2 11-27-2009 10:28 AM

All times are GMT +1. The time now is 12:39 PM.