Roadmap for version 2.3.15 Expand all | Collapse all
40% of 5 tasks completed. 3 open tasks:
- FS#161 - Extend order item export Expand Collapse
-
Extend the order item export with a few fields from the order export to allow for better order management. See http://www.csvimproved.com/forum/2-help/15538-product-status-problem.html
- FS#162 - Problem remote images Expand Collapse
-
Remote images with a non-descript URL creates invalid image names. See http://www.csvimproved.com/forum/24-help-registered-users/15533-problem-generating-thumbnails-with-remote-urls.html
- FS#163 - Clean up cron output Expand Collapse
-
When calling cron it could generate some warnings that are of no particular use. See http://www.csvimproved.com/forum/24-help-registered-users/15468-problem-with-cron-when-calling-virtuemart-function.html
Roadmap for version 3.0 Expand all | Collapse all
10% of 15 tasks completed. 14 open tasks:
- FS#130 - Re-organize debug log Expand Collapse
-
With the new debug logging system, a re-organizing of the debug report is needed to provide a cleaner debug report.
- FS#136 - Add product types to product import Expand Collapse
-
http://www.csvimproved.com/forum/2-help/9512-using-product-types-and-csvi/Page-3.html#11047
- FS#137 - Make calculations shopper group aware Expand Collapse
-
When making calculations, there are discount settings available on a per shopper group basis. These need to be included in the export.
- FS#138 - Option to select subcategories bases on parent category Expand Collapse
-
Further I would propose an extra select option in the Export template:
- Select only products of the selected category
or
- Select products of the selected category and subcategories
Whith a lot of (sub) categories it's far easier just selecting the main category.
An additional selection ($also_subcategories) needs to go in the view,
Productexport.php can be changed to:
/* Filter by product category */
/**
* We are doing a selection on categories, need to redo the query to make sure child products get included
* 1. Search all product ID's for that particular category
* 2. Search for all child product ID's
* 3. Load all products with these ids
*/
$productcategories = JRequest::getVar('productcategories', false);
$also_subcategories = JRequest::getVar('also_subcategories', false);
if ($productcategories && $productcategories[0] != '') {
/* If selected get products of all subcategories as well */
if ($also_subcategories) {
$q_subcat_ids = "SELECT category_child_id
FROM #__vm_category_xref
WHERE category_parent_id IN ('".implode("','", $productcategories)."')";
$db->setQuery($q_subcat_ids);
$subcat_ids = $db->loadResultArray();
$productcategories = array_merge($productcategories, $subcat_ids);
}
/* Get all product IDs */
$q_product_ids = "SELECT p.product_id
FROM #__vm_product p
LEFT JOIN #__vm_product_category_xref x
ON p.product_id = x.product_id
WHERE x.category_id IN ('".implode("','", $productcategories)."')";
$db->setQuery($q_product_ids);
$product_ids = $db->loadResultArray();
if ($product_ids != false) {
/* Get all child product IDs */
$q_childproduct_ids = "SELECT p.product_id
FROM #__vm_product p
WHERE p.product_parent_id IN ('".implode("','", $product_ids)."')";
$db->setQuery($q_childproduct_ids);
$childproduct_ids = $db->loadResultArray();
/* Now we have all the product IDs */
$product_ids = array_merge($product_ids, $childproduct_ids);
}
$selectors[] = '#__vm_product.product_id IN (\''.implode("','", $product_ids).'\')';
}
- FS#140 - Add export debug Expand Collapse
-
Add the option to collect debug information for exports. This will help in troubleshooting export issues.
- FS#142 - Child products get parent product URL Expand Collapse
-
On export give child products the product URL of their parent.
- FS#144 - Enable debug on export Expand Collapse
-
Allow for debug collection during an export for improving solution finding.
- FS#145 - Make field order obsolete Expand Collapse
-
Make the field order obsolete as this will make it more flexible to import data.
- FS#146 - Handle image URLs with no specific name Expand Collapse
-
Handle image URLs that are formed like http://imageserver/?id=234
- FS#147 - Support for duplicate SKUs Expand Collapse
-
A single product can be added multiple times but have different parents. This would cause a duplicate SKU.
- FS#151 - Remove alphanumeric characters from import price Expand Collapse
-
Importing a price as $4.45 currently fails. Removing the currency symbol from the price will allow the price to be imported.
- FS#152 - Add option to empty image names Expand Collapse
-
On import if an image is not found, empty the product_full_image and product_thumb_image field.
- FS#156 - Support for JoomFish translation on export Expand Collapse
-
On export have some product details taken from JoomFish for a translated export.
- FS#157 - Add case to generated imagenames Expand Collapse
-
When generating image names it now uses the capitalization of the item it is based on. It would be good to have the option to set the capitalization based on user choice. Choices can be:
- uppercase
- lowercase
- Uppercase first letter
Text Version