Get Article No from DB

English forums
1

Hi guys,

I try to write a extendsion for the oxid shop which allows to get the article data with an ajax request. For that purpose I would like to pass the article numbers to the module and search for the corresponding data in the db. However i cannot find the table/column in the db which contains the pure article numbers.

In the oxarticles is the column oxartnum but it shows different number as the admin interface.

Got anybody got a clue? I use the oxid professional edition 4.4.3_30016

Thanks in advance.
Cheers Nick

2

Hi Nick,

IMO, oxarticles:OXARTNUM shall be exactly the article number you entered in admin interface… No idea why it is different over there.

Regards

3

Hi Marco,

I think the ids are different because I copied a product a couple of times. Original id
000000-000001, id of the copy 000000-000001/2/-1/, 000000-000001/2/2/, …

can it be?