Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Changing the V_product_quantity


Recommended Posts

Instead of providing a number in the daily "Inventory Sheet", my supplier has a column

that states: "In Stock", - "Out of Stock" - or, "Low on Stock".


I suppose that EP is setup to take a numeric value in the v_products_quantity colum, so

I haven't tried putting these there.


So, first: Will EP take non-numeric values? and second if not, how can I convert it, or

create a colum for this purpose?



Link to comment
Share on other sites



By default the database table is set as


products_quantity int(4) NOT NULL,



I expect you could change it to


products_quantity varchar(64)



However, the may have to check the associated files to see how they are set up to ensure they are not expecting an integer as opposed to a text value.




Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...