Fixed number of rows in file export

-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.5.1

Hi,

Is there a way to have a fixed number of rows when exporting the order details from HikaShop? I'm using an accounting system to do all of my bookwork and I'm able to import the exported excel data from HikaShop. However, in order for this process to work, I need to have the same amount of rows each time the document gets exported because of the macro that's in place.

Currently what happens is that HikaShop exports a different number of rows based on how many products are in the order and thus each file comes out differently. I still need 1 item per row but need to have a fixed amount of rows for each document.

Is there a way to have all of the exported data files with the same amount of rows? or export the order data but with all the products I've loaded into HikaShop including the ones that have an order quantity of zero?

Hi Nicholas,

Sorry if my post was unclear.

So the CSV document exports all of the orders from the last 24 hours and has one order per column. In this column are the shoppers details and products ordered with each entry been placed in a separate row. The problem is that the number of rows in the CSV file changes every time because each order has a different amount of items ordered and thus more or less rows are added.

The system we are using is called SAP and it has to be set up to have a fixed number of import fields. Is there a way for the CSV file that gets exported from HikaShop to always have the same amount of rows every time the mass action exports a file?

I've attached 2 examples of the data that's been exported. I've removed the email address from the document for privacy reasons but otherwise this is the kind of data I'm working with.

Hi Nicholas,

You were right, I did get the rows and columns mixed up. Sorry about the confusion.

In the mass action, I am trying to export the following tables for each order that gets placed during the last 24 hours.

1st section
deliverydate (custom field)
order_billing_address_id
order_created
order_number
order_status

2nd section
order_product_name
order_product_quantity

4th section
sapcode (custom field)
user_email
user_id

5th section
name

As you can see I'm trying to get all the information regarding who ordered the products, what they ordered, the quantity, and their SAP billing details. But because of how SAP requires a fixed number of columns, the mass action export makes this difficult due to some orders having more products than others and thus every time the mass action is proformed, I get a CSV/XLS file with different amounts of columns each time. I downloaded and installed the plugin you recommended but am unsure of how it's changed anything.