I would really appreciate some guidance here please if anyone can spare a couple of minutes !
we have a large MSSQL database than runs our shops stock system. we are in the crazy situation of manually trying to stock check it against actinic on a daily basis. the suppliers will write whatever query we need at a price but dont have experience of actinic so their bill will clock up . ive read up loads but would appreciate someone confirming my interpretation ?
our two options are either:
1 to link through odbc (ideal to my way of thinking), then we will have live stock situation, and still continue to drag and drop products into sections at will , which our designer loves , modified prices in mssql will follow through etc , BUT , i cannot see the colour size fields when mapping , and money in mssql is in pounds.p .
2. to get a hierarchical file exported , with all the details,on a daily basis, the money converted to pence on the way , and then import this. then we will drag and drop each product into its relevant section,and they will retain their colour/size combinations,with price and stock level. when this file is imported will everything have to put back into its relevant section again, or will just new products need to be updated, and will stock levels be updated?we only want to show colour size combinations that are in stock / or be available to order
advice on the best route to go would be greatly appreciated , maybe mssql should make a new table with all the data we need in it on a daily basis,and we link to that , but i cannot see how to handle colour size options. Any advice on how to achieve this integration would be very gratefully received. If someone has the necessary experience and would like to be involved please contact me, but i would like this discussion to add to this marvellous support list , as although there is quite a lot of information on this subject here , its not in quite the laymans language i need as a selftaught fiddler !!
we have a large MSSQL database than runs our shops stock system. we are in the crazy situation of manually trying to stock check it against actinic on a daily basis. the suppliers will write whatever query we need at a price but dont have experience of actinic so their bill will clock up . ive read up loads but would appreciate someone confirming my interpretation ?
our two options are either:
1 to link through odbc (ideal to my way of thinking), then we will have live stock situation, and still continue to drag and drop products into sections at will , which our designer loves , modified prices in mssql will follow through etc , BUT , i cannot see the colour size fields when mapping , and money in mssql is in pounds.p .
2. to get a hierarchical file exported , with all the details,on a daily basis, the money converted to pence on the way , and then import this. then we will drag and drop each product into its relevant section,and they will retain their colour/size combinations,with price and stock level. when this file is imported will everything have to put back into its relevant section again, or will just new products need to be updated, and will stock levels be updated?we only want to show colour size combinations that are in stock / or be available to order
advice on the best route to go would be greatly appreciated , maybe mssql should make a new table with all the data we need in it on a daily basis,and we link to that , but i cannot see how to handle colour size options. Any advice on how to achieve this integration would be very gratefully received. If someone has the necessary experience and would like to be involved please contact me, but i would like this discussion to add to this marvellous support list , as although there is quite a lot of information on this subject here , its not in quite the laymans language i need as a selftaught fiddler !!
Comment