Resolved J2Store - Product Price Questions for both export & import

Hello Andy,

I loaded that patch file and it now exports all prices - Thank You.

Glad to know that export works as expected.

But this has released more questions & I hope it is OK to continue the discussion in this thread? If Not I am happy to open up a new post/thread.

Yes since we are discussing on the topic of prices, this thread should be fine.

For some odd reason, this adds the special prices, but rounds the main 2.95 price down to 2.00 ?

I found that the code is reading the integer part of the price and so 2.95 was going as 2.00 on import. Please load the attached patch file and run the import again.

patch_j2store_2018_09_12.zip

I loaded that patch file and it now exports all prices - Thank You.
But this has released more questions & I hope it is OK to continue the discussion in this thread? If Not I am happy to open up a new post/thread.

EXPORT
Where no "special" price is available the export shows this field as "0"
For example;

sku,regular_price,price,customer_group_name

L20-Nail-Polish-Gentle-Pink,2.95,0

IMPORT
If I want to re-import the above with special prices I am running into some odd issues;

I am using the same fields & this is what I tested first;

sku,regular_price,price,customer_group_name

L20-Nail-Polish-Gentle-Pink,2.95,0

L20-Nail-Polish-Gentle-Pink,2.95,0.46,Wholesale General

L20-Nail-Polish-Gentle-Pink,2.95,0.32,Wholesale Bulk

L20-Nail-Polish-Gentle-Pink,2.95,0.46,Export General

L20-Nail-Polish-Gentle-Pink,2.95,0.32,Export Bulk

For some odd reason, this adds the special prices, but rounds the main 2.95 price down to 2.00 ?

I then thought maybe the 1st price needs to be assigned to the "public" group ?
So I tried the following.
This adds 2.95 as a special price when viewing the "set prices" in J2Store[product backend], but the main price is still rounded down to 2.00 from 2.95 ?

sku,regular_price,price,customer_group_name

L20-Nail-Polish-Gentle-Pink,2.95,2.95,Public

L20-Nail-Polish-Gentle-Pink,2.95,0.46,Wholesale General

L20-Nail-Polish-Gentle-Pink,2.95,0.32,Wholesale Bulk

L20-Nail-Polish-Gentle-Pink,2.95,0.46,Export General

L20-Nail-Polish-Gentle-Pink,2.95,0.32,Export Bulk

I include some screenshots of this happening, have included the import CSV & Debug Log





Laval-Price-Import-Main.csv
com_csvi.log.57.zip

Hello Andy,
You are right. J2Store price export operation exports only the products with advanced prices and products with only regular price are ignored. I have fixed this issue and have attached a patch file for it. Please load the patch file and run the export. Let me know on how it goes.

patch_j2store_price_export_2018_09_12.zip

I noticed in the changelog for the 7.8 versions there were lots of updates for J2Store & in particular price import/export.
I've updated everything and created new export/import templates, but when running a full price export, CSVi, is only exporting prices for products that have special prices?

I would have expected this to export all prices, for all products & where special prices are used, then these exported too? Am I misunderstanding this?
Thanks, Andy :blink:
Price-2.csv
com_csvi.log.45.zip

Ah OK, I will use that as a workaround for now

Hello Andy,
Thank you for sending the debug log. As of now regular price of a J2Store product is supported in J2Store product export and J2Store price export is only for advanced prices. We need to think on how we can get both regular and advanced prices in J2Store price export. We will look into this and let you know on what we come up with.

Debug Log Added
com_csvi.log.33.zip

Hello Andy,
Can you post your export debug log to check?