| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
#1
|
|||||||
|
|||||||
Product ID
Having recently switched from Xcart 4 to Xcart 5, I'm struggling to understand the role of Product ID in Xcart 5. Note, out internal CRM is not linked to Xcart.
In 4, when I added new products, I did so by import to control the Product ID name, and match it with the SKU. Otherwise, the Product ID would be randomly generated. Matching Product ID and SKU make future product updates via import easier. In 5, the Product ID is randomly generated again when adding a new product manually, but it doesn't seem to be a required field for import, only SKU. So I'm thinking I no longer need to worry about them matching. Is there something I might be missing? I add new products regularly, and would like to update several of them at once in the future using import. I don't want Product ID to be an issue. Thanks in advance!
__________________
Dawn X-Cart Business 5.3.6.3 Mods: Qty input - Custom Mod Part numbers near title - Custom Mod Membership approval before ordering - Custom Mod Order Forms - Custom Mod Freight on Board - Custom Mod Catalog Order Form Call For Price Template: Crisp White skin Running on Windows |
|||||||
#2
|
|||||||||
|
|||||||||
Re: Product ID
Product ID is never random. As with any other ID for any other entity - customer, order, category, etc. The ID field is the unique identifier for the corresponding table in the database and is a sequential number. Always increments by 1 (unless the actual table is set differently which is almost never the case) from the last id.
If last product you added has an id of 10 the next one will have an id of 11. If you delete the product with an id of 10 the next one will be 12 - since there is 11. Look at these IDs as unique IDs for internal use. You don't need to know the id or reference it unless you are using dynamic urls for storefront or trying to access the record in the backend with direct url. Importing new or existing products (update) - no need to know or reference the id. The sku is enough to identify the product as it is unique.
__________________
Steve Stoyanov CFLSystems.com Web Development |
|||||||||
|
#3
|
|||||||
|
|||||||
Re: Product ID
Thank you, that is very helpful! Can I add new products with a CSV and choose the Product ID, like I was able to in xcart 4? What is the import field called? It was "!productid" in X4
__________________
Dawn X-Cart Business 5.3.6.3 Mods: Qty input - Custom Mod Part numbers near title - Custom Mod Membership approval before ordering - Custom Mod Order Forms - Custom Mod Freight on Board - Custom Mod Catalog Order Form Call For Price Template: Crisp White skin Running on Windows |
|||||||
#4
|
|||||||
|
|||||||
Re: Product ID
Also, can I export products and include the Product ID as a column?
__________________
Dawn X-Cart Business 5.3.6.3 Mods: Qty input - Custom Mod Part numbers near title - Custom Mod Membership approval before ordering - Custom Mod Order Forms - Custom Mod Freight on Board - Custom Mod Catalog Order Form Call For Price Template: Crisp White skin Running on Windows |
|||||||
#5
|
|||||||||
|
|||||||||
Re: Product ID
No and no. Unless you have custom module to extend the stock behavior and process ids
__________________
Steve Stoyanov CFLSystems.com Web Development |
|||||||||
|
|
Thread Tools | Search this Thread |
|
|
|
|||
X-Cart forums © 2001-2020
|