HIKASHOP ESSENTIAL 60€The basic version. With the main features for a little shop.
HIKAMARKETAdd-on Create a multivendor platform. Enable many vendors on your website.
HIKASERIALAdd-on Sale e-tickets, vouchers, gift certificates, serial numbers and more!
MARKETPLACEPlugins, modules and other kinds of integrations for HikaShop
-- HikaShop version -- : 4.3.0
Hi,
I wanted to export my orders to excel with the mass action function. I tried to export all datas. I downloaded the files but I noticed that datas about products are missing (
item1_order_product_id , item1_order_id ,item1_product_id item1_order_product_quantity, item1_order_product_name item1_order_product_code item1_order_product_price item1_order_product_tax item1_order_product_tax_info item1_order_product_options
I would need this data...
What can I do?
(It's working by export via the orders webpage)
Please Log in or Create an account to join the conversation.
Hi,
Please replace the function "organizeExportColumn()" in Administrator/components/com_hikashop/classes/massaction.php by this one:
function organizeExportColumn($data,$table,&$elements,&$action,&$types){
switch($data){
case 'product':
switch($table){
case 'product':
$ids = array();
$database = JFactory::getDBO();
foreach($elements as $element){
if(isset($element->product_parent_id->id)){
$ids[] = $element->product_parent_id->id;
}else if($element->product_parent_id){
$ids[] = $element->product_parent_id;
}
}
if(!empty($ids)){
$tIds = array();
foreach($ids as $id){
if(isset($id->id))
$tIds[(int)$id->id] = (int)$id->id;
elseif($id != 0)
$tIds[(int)$id] = (int)$id;
}
if(empty($tIds))
$tIds = array(0);
$query = 'SELECT product_id, product_code';
$query .= ' FROM '.hikashop_table('product');
$query .= ' WHERE product_id IN ('.implode(',',$tIds).')';
$database->setQuery($query);
$rows = $database->loadObjectList();
foreach($elements as &$element){
$id = $element->product_parent_id;
$element->product_parent_id = '';
if(!isset($types['product_parent_id']))
$types['product_parent_id'] = new stdClass();
$types['product_parent_id']->type = 'text';
foreach($rows as $row){
if(isset($id->id) && $id->id != $row->product_id){continue;}
$element->product_parent_id = $row->product_code;
}
unset($element);
}
}
break;
case 'related':
$ids = array();
$database = JFactory::getDBO();
foreach($elements as $element){
$ids[] = $element->product_id;
}
$query = 'SELECT pr.product_id, p.product_code';
$query .= ' FROM '.hikashop_table('product').' AS p';
$query .= ' INNER JOIN '.hikashop_table('product_related').' AS pr ON pr.product_related_id = p.product_id';
$query .= ' WHERE pr.product_id IN ('.implode(',',$ids).')';
$database->setQuery($query);
$rows = $database->loadObjectList();
$types['related']->type = 'text';
foreach($elements as $element){
foreach($element as $key=>$related){
if($key == 'related'){
foreach($related as $product){
$product->related = '';
foreach($rows as $row){
if($element->product_id != $row->product_id){continue;}
$product->related = $row->product_code;
}
}
}
}
}
break;
case 'category':
unset($action['category']);
$database = JFactory::getDBO();
$ids = array();
foreach($elements as $element){
foreach($element as $key=>$data){
if($key == 'category'){
foreach($data as $category){
if(isset($category->category_id)){
$ids[] = (int)$category->category_id;
}
}
}
}
}
if(!empty($ids)){
$query = 'SELECT DISTINCT category_name, category_id';
$query .= ' FROM '.hikashop_table('category');
$query .= ' WHERE category_id IN ('.implode(',',$ids).')';
$database->setQuery($query);
$rows = $database->loadObjectList();
foreach($elements as $element){
foreach($element as $key=>&$data){
if($key == 'category'){
foreach($data as &$category){
if(isset($category->category_id)){
$array = array();
foreach($rows as $row){
if($row->category_id == $category->category_id){
$array[] = $row->category_name;
}
}
$category->categories = $this->separator($array,$data,$table);
$types['categories'] = new stdClass();
$types['categories']->type = 'text';
$action['category']['categories'] = 'categories';
}
unset($category);
}
}
unset($data);
}
}
}
break;
}
break;
case 'user':
switch($table){
case 'address':
foreach($elements as &$element){
if(!isset($element->address)){continue;}
foreach($element->address as $k=>$address){
if($address->address_default != 1){
unset($element->address[$k]);
}
}
unset($element);
}
break;
}
break;
case 'category':
//unset($action['category']);
$database = JFactory::getDBO();
$ids = array();
foreach($elements as $category){
if(isset($category->category_id)){
$ids[] = (int)$category->category_id;
}
if(isset($category->category_parent_id)){
$ids[] = (int)$category->category_parent_id->id;
}
}
if(!empty($ids)){
$query = 'SELECT DISTINCT category_name, category_id';
$query .= ' FROM '.hikashop_table('category');
$query .= ' WHERE category_id IN ('.implode(',',$ids).')';
$database->setQuery($query);
$rows = $database->loadObjectList();
foreach($elements as &$category){
if(isset($category->category_parent_id->id)){
$array = array();
foreach($rows as $row){
if($row->category_id == $category->category_parent_id->id){
$array[] = $row->category_name;
}
}
$category->parent_category = $this->separator($array,$data,$table);
if(!isset($types['parent_category']) || !is_object($types['parent_category']))
$types['parent_category'] = new stdClass();
$types['parent_category']->type = 'text';
$action['category']['parent_category'] = 'parent_category';
}
if(isset($category->category_id)){
$array = array();
foreach($rows as $row){
if($row->category_id == $category->category_id){
$array[] = $row->category_name;
}
}
$category->categories = $this->separator($array,$data,$table);
if(!isset($types['categories']) || !is_object($types['categories']))
$types['categories'] = new stdClass();
$types['categories']->type = 'text';
//$action['category']['categories'] = 'categories';
}
unset($category);
}
}
break;
case 'order':
switch($table){
case 'address':
if(isset($action['address'])){
foreach($elements as &$element){
$element->shipping_address = array();
$element->billing_address = array();
if(!isset($element->address)){continue;}
foreach($element->address as $address){
if($address->address_id === $element->order_shipping_address_id || $address->address_id === $element->order_billing_address_id){
// Reverse the order of these elements to have the shipping address first
if(!isset($action['shipping_address'])) $action['shipping_address'] = array();
if(!isset($action['billing_address'])) $action['billing_address'] = array();
}
if($address->address_id === $element->order_shipping_address_id && $address->address_id === $element->order_billing_address_id){
$object = new stdClass();
foreach($address as $column=>$value){
if(!isset($action['address'][$column])){continue;}
$billing_column = 'billing_'.$column;
$action['billing_address'][$billing_column] = $billing_column;
$object->$billing_column=$value;
if(!isset($types[$billing_column])) $types[$billing_column] = new stdClass();
$types[$billing_column]->type = $types[$column]->type;
$shipping_column = 'shipping_'.$column;
$action['shipping_address'][$shipping_column] = $shipping_column;
$object->$shipping_column=$value;
if(!isset($types[$shipping_column])) $types[$shipping_column] = new stdClass();
$types[$shipping_column]->type = $types[$column]->type;
}
$element->billing_address[] = $object;
$element->shipping_address[] = $object;
}else if($address->address_id === $element->order_shipping_address_id){
$object = new stdClass();
foreach($address as $column=>$value){
if(!isset($action['address'][$column])){continue;}
$shipping_column = 'shipping_'.$column;
$action['shipping_address'][$shipping_column] = $shipping_column;
$object->$shipping_column=$value;
if(!isset($types[$shipping_column])) $types[$shipping_column] = new stdClass();
$types[$shipping_column]->type = $types[$column]->type;
}
$element->shipping_address[] = $object;
}else if($address->address_id === $element->order_billing_address_id){
$object = new stdClass();
foreach($address as $column=>$value){
if(!isset($action['address'][$column])){continue;}
$billing_column = 'billing_'.$column;
$action['billing_address'][$billing_column] = $billing_column;
$object->$billing_column = $value;
if(!isset($types[$billing_column])) $types[$billing_column] = new stdClass();
$types[$billing_column]->type = $types[$column]->type;
}
$element->billing_address[] = $object;
}
}
unset($element);
}
unset($action['address']);
}
break;
case 'order_product':
if(isset($action['order_product'])){
foreach($elements as &$element){
$cpt = 1;
if(!isset($element->order_product)){continue;}
if(!isset($element->order_full_tax)){
$element->order_full_tax = new stdClass();
$element->order_full_tax->value = 0;
// $action['order']['order_full_tax'] = 'order_full_tax';
$types['order_full_tax'] = new stdClass();
$types['order_full_tax']->type = 'price';
}
if(!isset($element->order_shipping_tax->value)){
$tmpValue = (int)$element->order_shipping_tax;
$element->order_shipping_tax = new stdClass();
$element->order_shipping_tax->value = $tmpValue;
}
if(!isset($element->order_discount_tax->value)){
$tmpValue = (int)$element->order_discount_tax;
$element->order_discount_tax = new stdClass();
$element->order_discount_tax->value = $tmpValue;
}
$element->order_full_tax->value += (int)$element->order_shipping_tax->value - (int)$element->order_discount_tax->value;
$element->order_full_tax->currency = $element->order_currency_id;
foreach($element->order_product as $product){
if(isset($product->order_product_quantity) && isset($product->order_product_tax)){
$element->order_full_tax->value+=round($product->order_product_quantity*$product->order_product_tax,2);
}
$tablename = 'product'.$cpt;
$object = new stdClass();
foreach($product as $column=>$value){
if(!isset($action['order_product'][$column])){continue;}
$product_column = 'item'.$cpt.'_'.$column;
if(!isset($action[$tablename]))
$action[$tablename] = new stdClass();
$action[$tablename]->$product_column = $product_column;
$object->$product_column = $value;
$types[$product_column] = new stdClass();
if(isset($types[$column]->type)){
$types[$product_column]->type = $types[$column]->type;
}else{
$types[$product_column]->type = '';
}
}
$element->$tablename = array($object);
$cpt++;
}
unset($element);
}
unset($action['order_product']);
}
break;
case 'joomla_users':
if(isset($action['joomla_users']) && isset($elements[0]->joomla_users)){
foreach($elements as $element){
foreach($element->joomla_users as $joomla_users){
foreach($joomla_users as $column=>$value){
$types[$column] = new stdClass();
if(!isset($types[$column]->type)){
$types[$column]->type = '';
}
}
}
}
}
break;
}
break;
}
}Please Log in or Create an account to join the conversation.
Hi,
We're having the exact same issue. Export from the orders page works fine, but but order_product fields are displaying duplicates of the customer names instead of product data in the CSV Export mass action.
If we use the CSV export mass action to only export product data for testing purposes (for example product_name), then the fields are empty.
Is there something we can do to solve that issue?
Please Log in or Create an account to join the conversation.
Hi,
Which version of HikaShop are you using ?
Could you do a screenshot of how you configured your mass action ?
Please Log in or Create an account to join the conversation.
Hi, we are using 2.4.0
Please Log in or Create an account to join the conversation.
Hi,
Please update you HikaShop version, this issue has been fixed and the fix is present in the release 2.5.0 available from our website here:
www.hikashop.com/my-account/your-subscriptions.html
Please Log in or Create an account to join the conversation.
