User access to the list of orders in the webshop

  • Posts: 50
  • Thank you received: 4
  • Hikashop Business
6 years 6 months ago #280740

-- HikaShop version -- : 3.2.0.
-- Joomla version -- : 3.8.1

Is it possible to give an user a very limited access to only download the list of orders (csv) that were ordered in the webshop?
Or send an e-mail the user with the order list?

Thanks in advance

Last edit: 6 years 6 months ago by WJ.

Please Log in or Create an account to join the conversation.

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
6 years 5 months ago #280745

Hi,

It's not possible to give access to the list of all the orders on the frontend.
It's however possible to send a CSV of the order list by email using a mass action (menu System>Mass action) with an action export the CSV file) and specify the email address there.
www.hikashop.com/support/documentation/167-massaction-form.html

Please Log in or Create an account to join the conversation.

  • Posts: 50
  • Thank you received: 4
  • Hikashop Business
6 years 5 months ago #280808

Thanks Nicolas,
Found the mass action and it's working.
The plugin is sending out the orderlist when an order is created, is it possible to send out an e-mail when an order is paid instead of when an order is created?

Please Log in or Create an account to join the conversation.

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
6 years 5 months ago #280815

Hi,

Sure. use the "after an order is updated" trigger, with a filter to check the order_status.

Please Log in or Create an account to join the conversation.

  • Posts: 50
  • Thank you received: 4
  • Hikashop Business
6 years 5 months ago #280857

Thanks again for the quick reply, must have overlooked it.
I have another question:
The webshop owner has a cash register system and he want's to put al the data from the webshop orders in the cash system.
The man from the cash register system told me he needs a xml 'stream' he can pull from the webshop hosting via the cash register.
Is there a kind of plugin or workaround to create this xml?

Please Log in or Create an account to join the conversation.

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
6 years 5 months ago #280859

Hi,

Well. There is, but it probably won't be exactly what they want.
The ShipStation plugin is a plugin which works like that:
www.hikashop.com/support/documentation/3...n-plugin-method.html
ShipStation's servers use a specific URL to connect to it on your website to get a XML of the orders periodically.

The following user(s) said Thank You: WJ

Please Log in or Create an account to join the conversation.

  • Posts: 50
  • Thank you received: 4
  • Hikashop Business
6 years 5 months ago #280902

Hello nicolas,
I have installed the plugin and played around with it.
Via the url i can connect to the XML via Excel by filling in the user/password, however the file stays empty.
The webshop is a fish/foodstore where the customers pick up the ordered fooddishes.
They don't ship or deliver so there is no shipping/postal service active on the webshop, except the custom pick up from the store witch is the default shipping method.

Could that be the problem why the xml is empty?
Is there a workaround to push the orders to the xml?

I do think this could be the solution we are looking for, thanks for the great support!!

Please Log in or Create an account to join the conversation.

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
6 years 5 months ago #280916

Hi,

If the XML is empty it can come from several reasons.
The orders won't be picked if the start and end dates in the URL are in the wrong format, or if the order is outside their range.
It won't either if it doesn't have a shipping address set.
And it won't if you configured the plugin to work on "paid" orders only and the order hasn't been confirmed.

But then, you can always change the code to remove these restrictions so that it works like you need it to.

The following user(s) said Thank You: WJ

Please Log in or Create an account to join the conversation.

  • Posts: 50
  • Thank you received: 4
  • Hikashop Business
6 years 5 months ago #280946

Okay nicolas,
Let me explain the orderprocess to make things clear because it's quiet simple.
A costumer orders a foodproduct from the webshop.
He/she had to fill in their address and so on.
But also the date when he/she picks up the order, done via the datepicker.
Now there is another parameter which is not a default setting, the timespan a costumer picks up the order.
I have done this via a custom dropdown selection, costumers can choose from 10am to 11am, 11 am to 12pm, 12pm to 13pm and so on.
The costumer picks the order from the shop (in the Netherlands)

My questions are:
What do you mean with 'order is outside their range'?
What is the correct date formatting setting and where can i change it.?
Do you think the shipstation plugin can drop all this data written above in the xml file?
How hard will it be 'changing the code to remove these restrictions'?

p.s. I can give you su access if you like to check things.

Thanks and regards

Please Log in or Create an account to join the conversation.

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
6 years 5 months ago #280985

Hi,

1. What I mean is that to call the URL of the shipstation plugin it looks like that:

http://localhost/Joomla%203.3.3/index.php?option=com_hikashop&ctrl=shipstation&SS-UserName=philippe&SS-Password=domoshima&action=export&test=1&start_date=10%2f8%2f2015+12%3a47&end_date=11%2f26%2f2015+18%3a55&page=1
You can see there a start_date and a end_date parameters. So the URL will give you a XML of the orders between these two dates.

2. You can see the format is a URL encoded date format like that: 10/8/2015 12:47
If you want another format, you can use any date format supported by strtotime:
php.net/manual/fr/function.strtotime.php

3. Yes I do.

4. It depends what you need but it doesn't look difficult. A seasoned PHP developer shouldn't have much problem doing it.

Please Log in or Create an account to join the conversation.

  • Posts: 50
  • Thank you received: 4
  • Hikashop Business
6 years 5 months ago #281044

Thanks nicolas for all the help, i will report this to the owner of the webshop.

Please Log in or Create an account to join the conversation.

Time to create page: 0.074 seconds
Powered by Kunena Forum