Is there a way to rearrange layout of Export CSV

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.6.0

I'm in Hikashop -> Orders -> and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?

Hi,

You can potentially edit the view "order / export" in the backend template and there edit the "$this->orders" PHP object at the top of the file in order to change the columns ordering.
So it require PHP knowledges.

Hello, was reading a bit through the forum and couldn't really get a definitive answer. I need to either create a report or maybe a cron job to run, or maybe even just use the reports I already have to be able to export a couple things. I want to be able to export only certain fields on an order so I can keep a record as well as upload a list for my mailing address book. I generally use excel for keeping a record of all sales and used to manually type in user information as well as manually insert the same on USPS web site. This is too time consuming for me so i decided to try hikashop out. I purchased the business version and have a more than what I need in some areas and other areas it lacks. But over all it is a great product with great potential.

Question1: What are the steps I need to take to create a custom export for orders that are ready to ship.
Question2: if I make changes regarding the above question then will it effect ALL exports?
Question3: is there a better way to set the CSV delimiter other than modifying core code?
Question4: is there an intuitive way to create custom reports that will be sent to my email daily with a CSV attached with a list of orders ready to ship and a list of the people who made those orders that I can upload to USPS?

I should also add, I was ok with the extra data being passed in the export function from the orders page but it was a pain in the neck. So I created macros that would sanitize the data to my needs. But when I upgraded to Business my exports are different and my data after the macros is not correct.

I really have many many questions about hikashop and the possibilities of hikashop, and I think there is some sort of support right? I may want to utilize the support but keep my questions and answers in the forum here for future users such as myself. One of these questions I have is what can cron be used for.

Hi,

So with all these informations I think that you must use the mass actions.
In HikaShop > System > Mass Action, you can set up mass actions which can be launched at specific periods, or launched on changes, etc. So you can create an order mass action, triggered every days, filter on specific order statuses, and use the "export a csv file" action.

In this action, you can directly select the fields to export in your csv file, and you can fill the email address field to receive the csv file directly. The only thing which seems to be missing in your case is the ordering of the exported fields.

But that can be achieved with some PHP modifications in the plugin code.

Here is the mass action documentation:
www.hikashop.com/support/support/documen...massaction-form.html

So:
1/ Use the mass actions
2/ Via the mass actions, no this will not impact other exports
3/ In Configuration > Main > Files > "CSV separator" option.
4/ Idem than 1/

The support of HikaShop is done via this forum directly.

Ok I will have a look at creating a couple mass actions to do this. Can you tell me which file controls csv so I can edit it or create an override?

Massaction does sound like a great approach. Can you explain con a bit? In the context of hikasho that is.

Hi,

The file which is controlling the order export is the plugin "hikashop / massaction_order".
(plugins/hikashop/massaction_order/massaction_order.php, function onProcessOrderMassActionexportCsv() )

But you can create a new plugin, copy the current code, paste it in your plugin and adapt it to your needs.
That way you will have created a new action without editing the existing one.

Here is the developer documentation for the mass actions:
www.hikashop.com/support/support/documen...s-action-plugin.html

HI,

I think i have achieved the same sa your trying to do but for Amazon, after an order is payed for hikashop data is pushed into a custom DB table and exported as csv in the format required by amazon to dispatch from the warehouse, it works with multi item orders, and multi orders, I'm guessing we could convert this with very little work to do what you want. Happy to discuss further contact me via our site articconsultants.com/hikashop-development