You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi,
We have our own local system that stores customer and product data locally and a colleague of mine is in the process of developing methods of uploading product data directly from our local database files to the online database used by Kryptronic.
We have come across some difficulties, mainly to do with field types and some of them being of type text. For example in ecom_pricemap, regprice and whlprice are text fields not varchar. It seems a bit over the top especially since varchar can now be the same length as a text field.
Is there any plan to change these fields and would there be an impact if they were?
Offline
You could technically change those text fields to varchars, but be careful to ensure your varchar fields can support large amounts of text. Both regprice and whlprice support volume based pricing, so those fields may contain well over 255 characters. Use ALTER TABLE commands to change them, if you decide to. K9 will work just fine.
Offline