Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

adding a sku# field in admin section


ginkster

Recommended Posts

I am looking at the 'Add UPC, ISBN, SKU" contribution... I dropship all of my inventory, so having the SKU's would make things easier, as I could just forward them to shipping without having to search through the warehouse's databases for the items...

 

I haven't got it in yet, but there are 2 of them... anyone using them and know which is better/less buggy?

 

one is:

http://www.oscommerce.com/downloads.php/co...ions,182/type,3

 

and the other:

http://www.oscommerce.com/downloads.php/co...ions,644/type,3

 

I am leaning towards the 1st one

The only thing necessary for evil to flourish is for good men to do nothing

- Edmund Burke

Link to comment
Share on other sites

I've tried both, but am working on September CVS and not a March CVS which it seems to be based off. It seems some core coding was changed? Does anyone here have a solution for those changes?

 

Thomas Keats

A signature is something that reflects its user. - The dictionary

 

The question is not, 'to code, or not to code'

the question is, 'if we do not code, are we really alive?'

-- anonymous

Link to comment
Share on other sites

Hi,

 

I'm just curious, has anyone ever had a need to add the item# or sku# in the osCommerce system?

 

I have a client with 10 000 products that needs to track online sales via item# / sku#

 

Thanks! :D

 

If you don't have any other need for model# then use that. Of course the default size of 12 characters is pretty limiting. I expanded it to 20 in phpMyAdmin with no problems. I use it to hold SKUs for sidelines and ISBNs for books.

 

My Sideline SKUs are pseudo ISBN numbers that look like 99W-XXXX-YYY-ZZ

 

99W - Means it is an internal SKU

XXXX - the Product Number

YYY - the Category Number

ZZ - Style and Size Options

 

It is a little limiting because I can only have 999 categories with 9999 products in each and each product is limited to 1296 option alphanumeric combinations. ;). In other words I can only have 12,945,745,296 different inventory items and I don't think I will cross that threshold for quite some time. Currently we have about 100 categories and 10,000 product/option combinations in our offline database and are working to make that data suitable for OSCommerce.

Link to comment
Share on other sites

Hi,

 

I'm just curious, has anyone ever had a need to add the item# or sku# in the osCommerce system?

 

I have a client with 10 000 products that needs to track online sales via item# / sku#

 

Thanks! :D

 

If you don't have any other need for model# then use that. Of course the default size of 12 characters is pretty limiting. I expanded it to 20 in phpMyAdmin with no problems. I use it to hold SKUs for sidelines and ISBNs for books.

 

My Sideline SKUs are pseudo ISBN numbers that look like 99W-XXXX-YYY-ZZ

 

99W - Means it is an internal SKU

XXXX - the Product Number

YYY - the Category Number

ZZ - Style and Size Options

 

It is a little limiting because I can only have 999 categories with 9999 products in each and each product is limited to 1296 option alphanumeric combinations. ;). In other words I can only have 12,945,745,296 different inventory items and I don't think I will cross that threshold for quite some time. Currently we have about 100 categories and 10,000 product/option combinations in our offline database and are working to make that data suitable for OSCommerce.

 

And what of us that USE that Model field. Please advise!.

A signature is something that reflects its user. - The dictionary

 

The question is not, 'to code, or not to code'

the question is, 'if we do not code, are we really alive?'

-- anonymous

Link to comment
Share on other sites

This is a contribution in the downloads section that adds additional fields to the product table for SKUs and ISBN's.

 

I just happen to work to find ways around adding new stuff to the system because it makes upgrading more difficult. Plus my customers are happier when I find ways to do what they need with the existing software. It usually saves them 3 or 4 hours of programming which is a lot of money at $60.00 an hour.

Link to comment
Share on other sites

This is a contribution in the downloads section that adds additional fields to the product table for SKUs and ISBN's.  

 

I just happen to work to find ways around adding new stuff to the system because it makes upgrading more difficult. Plus my customers are happier when I find ways to do what they need with the existing software. It usually saves them 3 or 4 hours of programming which is a lot of money at $60.00 an hour.

 

Well, I had downloaded that contribution, and mangled my install, good thing I backed it up. Now I've found the 2nd release of the same contribution, and its in, but still having some problems.

 

As you see, all my options have seem to disappeard in doing a database backup...

 

New Backup

Do not interrupt the backup process which might take a couple of minutes.



No Compression (Pure SQL)



Download only (do not store server side)*



*Best through a HTTPS connection

 

And in -->Reports --> Orders, Customers, I get the following on a test order after applying this contribution. (Did I forget something??)

 

 

Orders   IMAGE_PRINTBack

Customer:  Thomas Keats

2-60 ******* Street West

******, ******

******, Array

Telephone: 705-***-****

E-Mail Address: [email protected]

Delivery To:  Thomas Keats

2-60 *********** West

*******, *******

*******, Array

Payment Method: Cash on Delivery

Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc)

1 x Intel D845GERG2 Motherboard

Fatal error: Call to undefined function: tep_currency_format() in /home/www/test.rainbowcomputers.ca/htdocs/admin/orders.php on line 218

 

Its been some time since I actually looked at code, (C or PHP) and even then it was in passing. Can someone help me out here please? (These are just the bugs I found thus far...)

 

I would also, like to have "admin's" email copy include any sku/upc/isbn that is specified for that product. Anyone have any idea for that one? Or perhaps just have it listed in a 'daily report' of what was purchased in the admin section... Either would make me happy.

 

 

Thomas Keats

A signature is something that reflects its user. - The dictionary

 

The question is not, 'to code, or not to code'

the question is, 'if we do not code, are we really alive?'

-- anonymous

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...