Archive for May, 2011

Excel rename images and prepend directory name

Excel rename images ...

Excel function to modify image filenames, it converts to all lower case, replaces spaces with hyphens and prepends a directory name to the string. “brands” is the directory that is added. “G2″ contains the original filename. =CONCATENATE("brands/",LOWER(SUBSTITUTE(G2,"...
Magento update stock levels after AFM delivery

Magento update stock...

<?php $dir = "/home/afm/incoming/deliveries"; $pattern = "*.CSV"; if (is_dir($dir)) { if ($dh = opendir($dir)) { // iterate over file list while (($filename = readdir($dh)) !== false) { if (fnmatch($pattern, $filename)) { $file= $dir . "/" . $filename; $row = 1; if (($handle...
Sage Product Import File Format

Sage Product Import ...

Stock Code : Mandatory A code of up to thirty alphanumeric characters to uniquely identify the product. Description : Optional The product name or description.  Use up to sixty characters. Tax Code : Optional The VAT rate to be applied by default when you raise a product invoice...