Hi, have returned to the product after a break and am excited to get into it. I plan on using the tool to power a magento site via excel exports of the data, rather than using it in the 'normal' way. I have a minor issue however. Magento import needs default values, for example, it has a setting for 'attribute set' and all the products using 'default' will be imported.
I have been using the scan and set to set up mapping for colours etc (works perfectly). Is there a way I could use the filtering options to insert 'default' into an option called Attribute Set, please.
By creating the extra database tables and making the changes to the config.advanced, I have managed to get the colour mapping perfectly, along with several other attributes. However would be great if I were able to insert a single value to all products.
Many thanks for your assistance.
Hi,
You could simply add a column to the `products` table with the required default value if that would do the trick - the following dbmod.php script will add the column `attribute_set` with the default value of 'default'...
<?php
set_time_limit(0);
require("includes/common.php");
$sql = "ALTER TABLE `".$config_databaseTablePrefix."products`
ADD `attribute_set` VARCHAR(255) NOT NULL DEFAULT 'default'";
database_queryModify($sql,$result);
print "Done.";
?>
Hope this helps!
Cheers,
David.
--
PriceTapestry.com