The utility allows you to manage the options assigned to your products but does not allow adding, modifying, or removing the option data. There is a separate utility for that here:

http://www.ecom-mods.com/php-advanced-csv-option-data-utility.php

The utilities have not been tested internally wih v6.5, but I have not receied any support request relating to issues with v6.5.

Daniel Ewers
Ecom-Mods.com

PHP extensions from Ecom-Mods.com
Rate Our Products & Services

Thank you Daniel, I'm creating a new store and need to export all the product options so I can import them to the new site. I thought it was included in the product inventory export but realized it wasn't. I'm hoping this will work, it sounds like what I need.

Thanks,
Phil

Daniel,
Does the advanced product data add-on let you download a product inventory that has the options for each product listed?

Thanks,
Phil

Hi Phil,

Yes, but it is by Option Group ID and not by the Group Name. There is a Option Group reference file that is downloadable in the utility admin that tells you the group name and id for each option group so the product CSV can be updated.

Daniel Ewers
Ecom-Mods.com

PHP extensions from Ecom-Mods.com
Rate Our Products & Services

When I use your PHP - Advanced CSV Product Data Utility 3.2


and I update the product numbers and pricing etc does it over write the images also? Do I have to upload images again?

You do not. You only need to include the pID and any columns you wish to update. Any other columns will remain the same as they are in the db.



Mike Beebe
President,
DataLinks Software Solutions
www.dlss.ca
Rate Me Here

ASP and PHP mods - www.dlss.ca/products.asp
Brand Name Clothing and Swimwear - www.ClothesAndThings.com
Send Gift Baskets to Canada and USA - www.SendLuv.com
Clothes Directory - Shop for Clothing Online - www.ClothesDirectory.net

how do I get your software to export the sku field? where where exactly do I set it?

Hi I use this on a couple of sites and love it money well spent, there is parameter provided to allow you to set the fields that you need.

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

ok where?

ok this is the export fields that are the default

Remove_Product Additional_Section_IDs Option_Group_IDs Coupon_IDs Related_Product_IDs Attribute_IDs Manufacturer_Name Drop_Shipper_Name Change_pID pID pName pSection pPrice pListPrice pWholesalePrice pDisplay pSell pDescription pLongdescription

where is this? All I want to add to it is the pSKU field

You really should be contacting the developer directly here is an example of one I use

$csvProdFields="pID,pSKU,pName,pSection,pManufacturer,pDropship,pDisplay,pOrder,pSell,pInStock,pStockByOpts,pPrice,pWholesalePrice,pListPrice,pWeight,pDims,pShipping,pShipping2,pTax,pExemptions,pGiftWrap,pDateAdded,pDescription,pLongdescription,pCustom1,pCustom2,pCustom3";

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

Hey Daniel,

I have a quick questions. I just bought this product in hopes that it would do what Phil (plelwebdesign) asked about. I am moving a site from Ecommerce Templates to Wordpress and need a CSV with all products and product options. Right now, I can only figure out how to get it to show the option group ID. This doesn't really help as I need it all in one file with the corresponding options and prices associated with those options. Is there any way to do this with your Utility or did I just waist my money? I sure hope this can be done as it would be a huge time savor for me. Reconnecting 600 products with products options doesn't sound too fun.

Also, is there a way to grab the photos and have them associated with each product?

Andrew Beaver

Hi Andrew,
It would be far easier to take a copy of the existing database you have and move it over to the wordpress site wouldn't it?

Then you would have all the data including the options, orders, categories and product image data etc.

If it's an access or MSSQL database you're currently on we can upsize it to MySql for you very quickly.



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

I need an updated copy I'm going from 6.54 to 6.73...I can't get the developer to respond? any suggestions?