SQL Help needed

[volumax]

Hi All,

 

I need some help here, I have products with multiple options and to link Osc to our accounts package i need to be able to output a product code compiled from mthe model number and option values.

 

I.E. Duty Belt: 0010 Size: 36 Colour: Black

 

the accounts package need to be passed this:-

 

001036BLK

 

I know this info can be rxtracted as it appears on the invoice but not in the format I need. I Have tried to extract the code that does this, but have been unsuccessful.

 

Your help would be appreciated.

 

TIA

Andy

[Rob123]

I think we need a little more information.

What contribution/module are you using to link Osc to your accounts package ?

 

The numbers can be parsed or RegEx'd out but how do you expect "Black" to be converted to "BLK"?

(For instance what does Yellow or Green convert to?)

Do you have or need a cross reference table?

 

Do you expect the response to be in "mySQL" or "PHP"?

 

I may not be able to provide your answer but I think the answers to the questions above may clear things up.

 

Robert

[♥Vger]

If you have a Product Code then add this as 'Model Number' when you set up a product in your catalog - and then this is all you have to grab.

 

Vger

[Rob123]

If you have a Product Code then add this as 'Model Number' when you set up a product in your catalog - and then this is all you have to grab.

 

Vger

<{POST_SNAPBACK}>

 

Sure... If you want to do things the EASY way.

J/K

Robert

[volumax]

Hi All,

 

Was rushed when posting as Current store (shopfactory need first aid, web designer no longer with us and he modded code external to SF).

 

1. I am wanting to use the MYOB contrib as this give a base out put in tab delimited file. Which our Acc package needs.

 

2. The acc package is Quick Books 2002 PRO UK Edition, (I know there is a contrib out out there but have not been able to get it to work as contrib is geared to US/Canada and UK version of QB has significant diferences, which Intuit UK want to charge us $600 just to give us the 5 or six field name differences!!!)

 

3. Out put as indicated above in #1 to a file in tab delimited format.

 

4. Translation of options is no problem as I am re-using Descriptions from old shop which read e.g. Select BLK for Black GRN for Green from options below.

 

5. Vger. To issue individual model # in fashion of 001036BLK would just cause bloat of the DB we have around 700 products about 75% have 9 size options and 5 colours for each product. I thought of doing that but then didn't want to type all of them in :'(

 

6. The modded contrib would be run manually at regular periods, using an incremental file naming routine and selecting only those orders which have had status set to processing upon return from CC gateway.

 

 

I hope I have made things a little clearer.

 

Thanks All

Andy