ginkster Posted November 23, 2002 Posted November 23, 2002 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
dreamscape Posted November 23, 2002 Posted November 23, 2002 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
strictlypc Posted November 26, 2002 Posted November 26, 2002 They are basically the same contributions. The first one was kind of confusing for people to install. Thus the second version was out to clear up some confusing installation instructions.
tkeats Posted November 27, 2002 Posted November 27, 2002 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
Guest Posted November 27, 2002 Posted November 27, 2002 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.
Guest Posted November 27, 2002 Posted November 27, 2002 Oh the numbers above includes over 9,000 books which aren't included in the SKU idea since they each have a unique ISBN already.
tkeats Posted November 27, 2002 Posted November 27, 2002 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
Guest Posted November 27, 2002 Posted November 27, 2002 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.
tkeats Posted November 28, 2002 Posted November 28, 2002 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
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.