Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Changing the V_product_quantity


sballen

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?

 

Thanks

Link to comment
Share on other sites

@@sballen

 

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.

 

 

Chris

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...