X-Cart forums

[info@sjidesign.com]

Can this be done?

I want the same product in about 4 categories (but they need to all be individual products, i.e. NOT the same product cloned). I need to have EXACTLY the same SKU product code for each of these 4 products.

Product number 178 Category 1 SKU Code 333456
Product number 179 Category 2 SKU Code 333456
Product number 180 Category 3 SKU Code 333456
Product number 181 Category 4 SKU Code 333456

Reason they need to be individual and not cloned is because I am using the next and previous mod and do not want the products skipping to the wrong category.

Thanks in advance for any help

Dan

[cflsystems]

You can have one product assign to as many categories you want and it will be same product, same sku, same info. From your post I am getting that you don't want this but rather have 4 different products with same information? You can't do this, sku must be unique. Also SE will not like this. If you do it you will have duplicate contents.

[info@sjidesign.com]

I think it can be done, looks as though it is something to do with the product_modify.php or include/func.product.php! although I could be wrong.

Been trying it for hours and hours just cannot get it to work.

Anyone have any ideas???????

Dan

[cflsystems]

You have to change xcart_products table as productcode is unique there and no matter what changes you make to php files the db will not let you have duplicate skus.

[ChristineP]

What Next/Prev mod are you using? I just tested this with the Next/Prev mod that we purchased and it works fine without skipping categories.

You do not need to clone or add a product more than once when you want them displayed in more than one category. When you add or modify a product you will select a "Main category" and you can select "Additional categories" by holding down the Ctrl key for a PC or the Command key for a Mac. Doing this allows the product to display in more than one category without having dups.

Any database will have a Primary Key, whether it's set by someone managing the database or default by the database with a numeric count of items added. If you check in your phpMyAdmin you will see large table set that X-Cart has for your entire store database. If you look around in your database you will find what fields and tables that are set with a constraint of being "Primary Key". The queries that are already in place for the cart, call out certain fields to compile information for the store front, statistics, an order, an invoice, order history, export/import, etc. For any database it is a very bad idea to have duplicate (item) numbers if this is a key indicator for store items, because the information compiled will be garbage and you'll have hundreds of lines of dups. If your issue is with keeping a "root item number" for items that you have with different sizes, colors, etc., then you need to approach this differently with product variants.

[info@sjidesign.com]

Anyone been able to get this working?

I am desperate for this.

Been trying to change the xcart_products table but whatever I do I still cannot use the same SKU on 2 products.

Regards

Dan