Reg point 4. I found text field for it. To make it clear it should be in Invoice Manager Configuration I think.

Regards, Marcin

hello Marcin,

1. I have just published a plugin you can download and install that will allow you to search through HikaShop products to import into an invoice when you're creating it. It's called "[EXTENSION] Search items - HikaShop", you can download it in your downloads area.

2. the current system only allows to import the products (with the previous plugin mentioned) not the customers for now.

The integration relies precisely in the ability to "not have to create" the invoices manually, but instead, invoices are created automatically when a new order is placed in HikaShop.

3. you mean you want invoices to be created even if the status is not "confirmed"?

Hi Germinal

Thanks for this update. This will help me a lot!
Now I can really enjoy this component - bravo. Having the same with customers would do the job completely.
If comes to point 3.
Now every generated invoice has status paid.
I would need invoice to be generated but with unpaid status. Then I can change payments accordingly to customer case. In my shop we are using deposit option for payment.

Regards, Marcin

Hi Again

I have noticed problem. After invoice is generated VAT is always empty.

Regards, Marcin

More problems

Component can see only base price of invoiced item. VAT, shipping and payment fee are ignored.

Regards, Marcin

Hi!

1. well in the current system the status is always marked as paid and the invoice generated only on "completed" status on the HikaShop order, but we can change that with small coding into the plugin.

2. VAT isn't imported to the items in the invoice? it should be.. maybe there's something we're missing. However, in IM there's no shipping field, so if we want to import this one, it should be as a "extra item" field.

if you want, I'll be glad to take a look at this in your site and adjust things. can you send me joomla and FTP access at support@ joomlathat.com ?

Hi

1. Yes, I would appreciate to have this option as in my business getting only deposit is very common.
2. Here creating invoice without all details can't be accepted and it must be reworked to make this component really HikaShop integrated. I need to have all invoice component included, VAT, shipping costs and payment costs (like for PayPal).

Unfortunately I can't give access to my website admin panel. This is live website and I can't disclose back-end content.

Finally I am sure, you can do all the fixes beeing professional developer And I wouldn't really give up with this fantastic designed tool.

Regards, Marcin

Hello Marcin,

1. ok, I will try to code in directly in the plugin as an option, where you can choose (or not) to have invoices created even if the order is not completed.

2. it's not about this, it's that IM doesn't have a separated cost for Shipping costs, for example. since different business handle it differently (some after tax, some before, etc), that's why I wanted to see how it worked on your site, to point you to the right direction to make it work for your case, or do a small code tweak myself.

since I can't have access to the website, do you have maybe a test invironment I can access to? or in the last case, can you maybe send me a screenshot of an order, where all these details appear (shipping, vat, payment costs) so I can see how this is structured in your website?

thanks!

I am online now and we can work on it.

1. This is not about creating invoice if order is not completed as this can be set in HikaShop. I need have option to make created invoice unpaid, it can be manually as option in IM.
2. I have checked table hikashop_order and all date is there, so just needs to be imported to your component

thanks Marcin,

I see the screenshot and the info, however I'm still missing some information.
I can see only the "total" tax but I don't know where this is applied. this is logically part of the 900 but I can't know if the other parts (shipping, payment) also have tax, if the tax applied is the same for all items or different, etc... do you think you can maybe do another screenshot (of the DB table if you want) so I can get a better global picture?
or if you want, just break the math down for me for this case again, not everybody calculates it the same way, so I want to see how yours works exactly..
thanks!

version from IM

all is taxed 20% in my shop except PayPal.
Attached table from DB. Please delete screenshots and this table from Forum.

Marcin, I would need one more screenshot. I'm working with the data you send me but HikaShop has many ways to calculte totals.
do you think you can make a screenshot of this order in the DB? in the table __hikashop_order, just open this one and make a screenshot
thanks!

Sure I can

thanks! just one more the table hikashop_order_product (the product for that order) thanks!

order_product

Thanks Marcin,

ok, here we go. I've uploaded a new version of the plugin, version 1.1.0 (hikashop plugin), that has two new things:

1. in the plugin parameters, you can choose if you want to create the invoice only on status confirmed, or other.

2. an issue is solved, so now the taxes, shipping, etc, should be correctly imported.

let me know.

Hi

Thanks for your work, I like your support.
1. Here I made a bit mess as my only concern was that generated invoice has always status Paid - but this can be changed once invoice is created. I found it today...
2. Here we are partially done. Shipping and payment is imported now, VAT looks to be calculated correct, but Invoice subtotal including VAT already and if I will apply VAT 20% another amount is added. VAT is included twice in total amount. Should be easy to fix

Regards, Marcin

Hello Marcin,

that's whay I told you a few days ago: since the PAYMENT fee does not include VAT in it, then this means that the VAT cannot be added at a "global" level because it will affect ALL rows.

that's why the system adds the VAT at an ITEM level. you will notice every item has VAT, except the payment one. do you know what I mean? this way every item is taxed correctly and the total of the invoice matches. you don't need to click the "global" VAT. do you know what I mean?

Marcin, not sure if you understood my last point...

we can remove the VAT in every individual item, and add it to global level, but this will mean that the payment row will also have VAT calculated. do you know what I mean?

hello Marcin,

indeed, we are not understanding each other.

I totally understand what you're saying. you want the VAT ticked at a global level, not applied on every item. I understand that.

Again, I'm going to try to explain what I was explaining before: no, it's not an easy minor mistake...

if we DON'T apply VAT in every row, but we apply it at the global level, like you want, then it will be applied in the "payment fee" row as well. and you DON'T want it in that row.. because you told me that it was non-VAT. do you understand what I'm saying? if you want me to change the plugin to apply the VAT at a global level, that's ok, but please be aware that then it will be applied to the payment fee too, and therefore the total won't match.

hope you understand me now...

I totally understand what you're saying. you want the VAT ticked at a global level, not applied on every item. I understand that.

NO, this is not my intention. My intention is to have correctly generated Invoice based on HikaShop details. On the beginning you know it was wrong as shipping and payment fee was not included. After update these two are included and thanks for that.

if we DON'T apply VAT in every row, but we apply it at the global level, like you want, then it will be applied in the "payment fee" row as well. and you DON'T want it in that row.. because you told me that it was non-VAT. do you understand what I'm saying? if you want me to change the plugin to apply the VAT at a global level, that's ok, but please be aware that then it will be applied to the payment fee too, and therefore the total won't match.

To me way you do it doesn't matter at all. I need only to have end effect as it should (which will comply with VAT regulations):
1. VAT calculated separate for each row as not always VAT is 20% (and this is not my specific requirement)
2. VAT should be displayed on Invoice (like now after ticking 20% VAT)

So, this is what I need.

Marcin

hi,

well, this is not how IM works. the tax shown on the global list view is only the tax marked on the global invoice checkbox. since you need tax per items, we're not using the global checbox so it does not show on the list.

all I can do is a little tweak to add a column in the main view of your installation to show the sum of the item taxes on the invoice, for your use. but that's all, it would be a "tweak" for your installation

Marcin,

it's not that "I don't want to make it right"..! that would make no sense. it's simply that IM works a different way, that's all. it does not have all the possibilites in the world, of course. if you find another invoice software that is integrated with Hikashop the way you want and it does exactly all you want, how you want it, then you should use it.
If you don't want to use IM and want another refund, then tell me.
I have modified the plugin so it would better fit your scenario, now I offered to tweak your IM to add the tax from the items into a new column view so you can see it on the list view, like you want. Honestly, I don't know what else I can do for you...
I'm saying this with all the good faith. The software is what it is. Other improvements will keep coming in future versions, of course, but that are major versions and take time to develop.
Please Marcin, have in mind that even you keep calling this "an issue", like it was a bug on the system, it is not, it's just the way it works.. if I changed that then I would have other hundred users complaining about it!

I keep feeling you're angry with us when I have tried to adapt this to your needs "as much as possible". I hope you understand what I'm saying. Again, if you don't want to use this because "it's not compatible with HikaShop" then maybe the best is to give another refund and we go separate ways...

All the best,
Germi

Dear Germi

I really don't want to depreciate your work. I said above that I love your component as is designed very well. Really will be using it with pleasure as this is what I was looking for.

To make all shorter, I will ask you for only one tweak. And if this will be for me only I have no problem to pay for it.
Please change for me way you calculating Invoice Subtotal. To sum this use column Value. This will sort out all my requirements.

Thanks in advance. Marcin

picture to explain

ok Marcin, thanks for understanding.
I think the picture didn't get attached. Can you send it directly to me at support@ joomlathat.com ?

thanks!

pic

great, thanks for the pic. so.. that's all you need? just to display this number differently...? or also in the invoice list view?

I'll be able to make this modification when I get back from holiday, in 5 days. Hope you can wait that long...

Hi
Not a problem I can wait. Unfortunately I made mistake and I need to ask for different modification.

Marcin