Does Znode have a routine for duplicating products?
Wed, 09/09/2009 - 22:37 — Mobile-Ingenuity
We would like to create a new product by duplicating an existing product and then making modifications to the new product. Does Znode have a utility for doing this?
Just change that ProductID on the end to the ProductID you want to copy FROM.
Then change the SKU (which automatically defaults to a windows like [SKU] + '-copy', which you will want to change, but this at least lets it go in OK.
The last thing to do is edit the product normally and assign some categories, which this routine doesn't attempt to do.
PRINT 'MAKE SURE TO CHANGE SKU!'
Yes, we do support that functionality. In the admin tool, there is a data manager section. In here, you are able to download and upload products from and to your store.
For your situation, you should download your products to a csv file.
Open it with a text editor like Notepad. (We recommend you not use excel, as it sometimes messes up the file format for when you go to upload it. Feel free to open the file in excel if it makes it easier to read, but save your changes from another application. However, if you want to make changes in excel, do so, but then open it up in Notepad after to make sure excel didn't add anything extra to your file like quotation marks or added spaces).
Copy your product(s) line you want to duplicate, and change the information to create a new product on a new line. Be sure to change the SKU for the new product, or the system won't recognize it as a new product, and will update the existing record instead. Once you make the changes you want, go ahead and save your changes and upload your products back to the store and you will have your new products.
Let us know if you have any further questions or issues with this process.
Thank you for your response. Just to clarify, the download and upload has the affect of copying the entire catalog and then replacing the entire catalog? So we would want to add the new products in ADDITION to the existing products rather than uploading new products a few at a time?
Yes, that is correct. It will take the entire catalog, then append, delete, or add products depending on what modifications you make to the downloaded products file once you do the upload.
A different way
While the download, edit, upload method probably works just fine, we rolled our own way to quickly duplicate a single product.
This assumes that you have direct access to the database (or that you're a developer and can put something like this into a web page).
It's just a good ol' INSERT INTO... SELECT FROM sql statement.
Here is all you need (with v. 5.0):
To copy a product (in the FLIPSCRIPT database)
INSERT INTO [FlipScript].[dbo].[ZNodeProduct] ([ProductNum], [SKU], [PortalID], [Name], [ShortDescription], [Description], [FeaturesDesc], [ProductTypeID], [RetailPrice], [SalePrice], [WholesalePrice], [ImageFile], [Weight], [Length], [Width], [Height], [ActiveInd], [DisplayOrder], [CallForPricing], [HomepageSpecial], [CategorySpecial], [InventoryDisplay], [Keywords], [ManufacturerID], [AdditionalInfoLink], [AdditionalInfoLinkLabel], [ShippingRuleTypeID], [SEOTitle], [SEOKeywords], [SEODescription], [Custom1], [Custom2], [Custom3], [ShipEachItemSeparately], [QuantityOnHand], [AllowBackOrder], [BackOrderMsg], [DropShipInd], [DropShipEmailID], [Specifications], [AdditionalInformation], [InStockMsg], [OutOfStockMsg], [TrackInventoryInd], [DownloadLink], [FreeShippingInd], [TaxExemptInd], [NewProductInd], [SEOURL], [MaxQty], [ShipSeparately], [FeaturedInd], [WebServiceDownloadDte], [UpdateDte])
SELECT [ProductNum], [SKU] + '-copy', [PortalID], [Name], [ShortDescription], [Description], [FeaturesDesc], [ProductTypeID], [RetailPrice], [SalePrice], [WholesalePrice], [ImageFile], [Weight], [Length], [Width], [Height], [ActiveInd], [DisplayOrder], [CallForPricing], [HomepageSpecial], [CategorySpecial], [InventoryDisplay], [Keywords], [ManufacturerID], [AdditionalInfoLink], [AdditionalInfoLinkLabel], [ShippingRuleTypeID], [SEOTitle], [SEOKeywords], [SEODescription], [Custom1], [Custom2], [Custom3], [ShipEachItemSeparately], [QuantityOnHand], [AllowBackOrder], [BackOrderMsg], [DropShipInd], [DropShipEmailID], [Specifications], [AdditionalInformation], [InStockMsg], [OutOfStockMsg], [TrackInventoryInd], [DownloadLink], [FreeShippingInd], [TaxExemptInd], [NewProductInd], [SEOURL], [MaxQty], [ShipSeparately], [FeaturedInd], [WebServiceDownloadDte], GETDATE()
FROM [FlipScript].[dbo].[ZNodeProduct]
WHERE ProductID = 399
Just change that ProductID on the end to the ProductID you want to copy FROM.
Then change the SKU (which automatically defaults to a windows like [SKU] + '-copy', which you will want to change, but this at least lets it go in OK.
The last thing to do is edit the product normally and assign some categories, which this routine doesn't attempt to do.
PRINT 'MAKE SURE TO CHANGE SKU!'
Yes
Hello,
Yes, we do support that functionality. In the admin tool, there is a data manager section. In here, you are able to download and upload products from and to your store.
For your situation, you should download your products to a csv file.
Open it with a text editor like Notepad. (We recommend you not use excel, as it sometimes messes up the file format for when you go to upload it. Feel free to open the file in excel if it makes it easier to read, but save your changes from another application. However, if you want to make changes in excel, do so, but then open it up in Notepad after to make sure excel didn't add anything extra to your file like quotation marks or added spaces).
Copy your product(s) line you want to duplicate, and change the information to create a new product on a new line. Be sure to change the SKU for the new product, or the system won't recognize it as a new product, and will update the existing record instead. Once you make the changes you want, go ahead and save your changes and upload your products back to the store and you will have your new products.
Let us know if you have any further questions or issues with this process.
Thanks,
Znode Administrator
email: support@znode.com
url: www.znode.com
Does Znode have a routine for duplicating products? Follow up..
Thank you for your response. Just to clarify, the download and upload has the affect of copying the entire catalog and then replacing the entire catalog? So we would want to add the new products in ADDITION to the existing products rather than uploading new products a few at a time?
Regards, John
Yes.
Yes, that is correct. It will take the entire catalog, then append, delete, or add products depending on what modifications you make to the downloaded products file once you do the upload.
Thanks,
Znode Administrator
email: support@znode.com
url: www.znode.com