You have no items in your shopping cart.

Tuesday, July 14, 2020 10:07:06 AM

Feature Requests

Avatar

Posted: 2 years ago

#6777 Quote

michaelm@gogbs.com

Posted: 2 years ago

#6777 Quote
Thanks.

I'm using the NOP 3.9.  

I just download the plugin.  I does not have the latest feature update.
Avatar

Posted: 2 years ago

#6783 Quote

Support

Posted: 2 years ago

#6783 Quote
I have fixed the problem with tier prices too.
Avatar

Posted: 2 years ago

#6862 Quote

michaelm@gogbs.com

Posted: 2 years ago

#6862 Quote
Would be nice to be able to set the Start Date and End Date of the TierPrices and Product Price.
Avatar

Posted: 2 years ago

#6920 Quote

michaelm@gogbs.com

Posted: 2 years ago

#6920 Quote
Would be nice when you do an export, if there are no tier prices then on the excel sheet fill that column with the empty curly brackets {} instead of blank.

We end up always manually adding the {} on every cell if our import has mixed prices (meaning some SKUs have tier prices and some don't)
Avatar

Posted: 2 years ago

#6921 Quote

Support

Posted: 2 years ago

#6921 Quote
I added your request.
Download new release and try it.
Avatar

Posted: 2 years ago

#6922 Quote

michaelm@gogbs.com

Posted: 2 years ago

#6922 Quote
Thanks for the quick response.

Works beautiful!  
Avatar

Posted: 2 years ago

#8047 Quote

michaelm@gogbs.com

Posted: 2 years ago

#8047 Quote
Hi,

Regarding the TierPrices:

1. Could you have the ability to set the Customer Role on the TierPrices?
2. And the ability to set a Start Date and End Date for the TierPrices?
Avatar

Posted: 2 years ago

#8049 Quote

Support

Posted: 2 years ago

#8049 Quote
I added this new feature (nop 3.90 and nop 4.00).
Download new release and try it.
Write me about result.
Avatar

Posted: 2 years ago

#8055 Quote

michaelm@gogbs.com

Posted: 2 years ago

#8055 Quote
The Customer Role for Tier Prices works fine.

However, the Start/End Date per Tier is not working for me.

I'll send you a copy of the test import sheet.
Avatar

Posted: 2 years ago

#8062 Quote

Support

Posted: 2 years ago

#8062 Quote
>However, the Start/End Date per Tier is not working for me.
I added support Start/End Date per Tier only for simple import, but I added support them in plain import too.
Be careful!!
I changed the tier price format
{Quantity:Price:CustomerRoleId:StoreId:StartDate:EndDate}
Example
45,100,0,100,"{1:30.00:0:1:03/08/2019:04/08/2019;}"
Avatar

Posted: 2 years ago

#8065 Quote

michaelm@gogbs.com

Posted: 2 years ago

#8065 Quote
Tried the Start/End Time on TierPrices and there are issue.

I'll send you copies of the test import file and the logs.

Below are lines from the log:

Quantity=100, CustomerRoleId=11, Price=11, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
Quantity=1, CustomerRoleId=, Price=0, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=1/1/0001 12:00:00 AM

1. I'm passing 0 to the CustomerRoleId and it's correctly setting it as empty, but not for StoreId.
2. Looks like Price is reading the CustomerRoleId
2. StartDateTimeUtc is not reading anything
3. EndDateTimeUtc is getting a weird NULL date value.
Avatar

Posted: 2 years ago

#8066 Quote

Support

Posted: 2 years ago

#8066 Quote
No, I wrote I changed the format.
Old format
quantity:customerroleID:price
new format
quantity:price:customerroleID:storeid,startdate,enddate

Please set the price to the second position.
Do it and write me about result.

Avatar

Posted: 2 years ago

#8067 Quote

Support

Posted: 2 years ago

#8067 Quote
Open the file Global.asax in site root folder and add spacebar to the end of the file.
I want to be sure that IIS uses new DLL file too.
Avatar

Posted: 2 years ago

#8073 Quote

michaelm@gogbs.com

Posted: 2 years ago

#8073 Quote
I have access to IIS and restarted the site to make sure the latest 1.12 of the DLL is loaded.

I send a copy of the test import file and the log.

1. This version does not allow multiple tier prices for the same quantity.  The last record overwrites the other quantities.
2. This format does not work for TierPrices {quantity:price:customerrolerid}
3. The End Date looks like it's copying the Start Date.

Sample record:

GNQS00-019,30,0,30,{1:30.0000;5:28.0000;10:26.0000;25:24.0000;50:22.0000;100:20.0000;1:28.0000:11;5:26.0000:11;10:24.0000:11;25:22.0000:11;50:20.0000:11;100:18.0000:11;1:28.0000:0:0:02/04/2018:05/04/2018;5:26.0000:0:0:02/04/2018:05/04/2018;10:24.0000:0:0:02/04/2018:05/04/2018;25:22.0000:0:0:02/04/2018:05/04/2018;50:20.0000:0:0:02/04/2018:05/04/2018;100:18.0000:0:0:02/04/2018:05/04/2018;}



What the Log is seeing:

    row.ProductKey=GNQS00-019,row.Price=30, row.ProductCost=0, row.OldPrice=30
                 Quantity=1, CustomerRoleId=, Price=30.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=5, CustomerRoleId=, Price=28.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=10, CustomerRoleId=, Price=26.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=25, CustomerRoleId=, Price=24.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=50, CustomerRoleId=, Price=22.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=100, CustomerRoleId=, Price=20.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=1, CustomerRoleId=, Price=28.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=5, CustomerRoleId=, Price=26.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=10, CustomerRoleId=, Price=24.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=25, CustomerRoleId=, Price=22.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=50, CustomerRoleId=, Price=20.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=100, CustomerRoleId=, Price=18.0000, StoreId=0, StartDateTimeUtc=, EndDateTimeUtc=
                 Quantity=1, CustomerRoleId=, Price=28.0000, StoreId=0, StartDateTimeUtc=4/2/2018 12:00:00 AM, EndDateTimeUtc=4/2/2018 12:00:00 AM
                 Quantity=5, CustomerRoleId=, Price=26.0000, StoreId=0, StartDateTimeUtc=4/2/2018 12:00:00 AM, EndDateTimeUtc=4/2/2018 12:00:00 AM
                 Quantity=10, CustomerRoleId=, Price=24.0000, StoreId=0, StartDateTimeUtc=4/2/2018 12:00:00 AM, EndDateTimeUtc=4/2/2018 12:00:00 AM
                 Quantity=25, CustomerRoleId=, Price=22.0000, StoreId=0, StartDateTimeUtc=4/2/2018 12:00:00 AM, EndDateTimeUtc=4/2/2018 12:00:00 AM
                 Quantity=50, CustomerRoleId=, Price=20.0000, StoreId=0, StartDateTimeUtc=4/2/2018 12:00:00 AM, EndDateTimeUtc=4/2/2018 12:00:00 AM
                 Quantity=100, CustomerRoleId=, Price=18.0000, StoreId=0, StartDateTimeUtc=4/2/2018 12:00:00 AM, EndDateTimeUtc=4/2/2018 12:00:00 AM
Avatar

Posted: 2 years ago

#8074 Quote

Support

Posted: 2 years ago

#8074 Quote
Thank you I'll check it now.
Avatar

Posted: 2 years ago

#8075 Quote

Support

Posted: 2 years ago

#8075 Quote
1. This version does not allow multiple tier prices for the same quantity.  The last record overwrites the other quantities.
I tried to find the tier price with the same quantity and customerroleid and storeId and replace it.
I didn't want to add new tier price and wanted to replace old one....
I want to think....

>2. This format does not work for TierPrices {quantity:price:customerrolerid}
Fixed
>3. The End Date looks like it's copying the Start Date.
Fixed
Avatar

Posted: 2 years ago

#8076 Quote

Support

Posted: 2 years ago

#8076 Quote
Try new release.
I decided to use your logic.
If tier price has the same quantity, customerroleit, storeid, start and end dates plugin will update existing tier price.
Avatar

Posted: 2 years ago

#8081 Quote

michaelm@gogbs.com

Posted: 2 years ago

#8081 Quote
v1.13 works.  T

he new Import logic works beautifully.  It addresses real world needs, where a store can have multiple tier prices for the same quantity for different Roles (e.g. Business Customers, Preferred Customers) or set a schedule for sale price ahead of time (for Sales calendars are set months ahead).

One issue though is the Export.  The Export is missing the data for CustomerRoleId, StoreId, StartDate and EndDate.


Imported this:  

GNQS00-019,30,0,30,{1:30.0000;5:28.0000;10:26.0000;25:24.0000;50:22.0000;100:20.0000;1:28.0000:11;5:26.0000:11;10:24.0000:11;25:22.0000:11;50:20.0000:11;100:18.0000:11;1:28.0000:0:0:02/04/2018:05/04/2018;5:26.0000:0:0:02/04/2018:05/04/2018;10:24.0000:0:0:02/04/2018:05/04/2018;25:22.0000:0:0:02/04/2018:05/04/2018;50:20.0000:0:0:02/04/2018:05/04/2018;100:18.0000:0:0:02/04/2018:05/04/2018;}


The Plugin correctly updates the Tier Prices.  When I attempted to export the same record, this is returned:

GNQS00-019,30.0000,0.0000,30.0000,{1:30.0000;5:28.0000;10:26.0000;25:24.0000;50:22.0000;100:20.0000;1:28.0000;5:26.0000;10:24.0000;25:22.0000;50:20.0000;100:18.0000;1:28.0000;5:26.0000;10:24.0000;25:22.0000;50:20.0000;100:18.0000;}

Avatar

Posted: 2 years ago

#8082 Quote

Support

Posted: 2 years ago

#8082 Quote
Version 2.07 - April 04, 2018
Version 1.14 - April 04, 2018

+ changed the export format for tier prices. The new format (quantity:price:customerRoleId:storeId:startDate,EndDate)

Avatar

Posted: 2 years ago

#8089 Quote

michaelm@gogbs.com

Posted: 2 years ago

#8089 Quote
Downloaded, installed, restarted IIS, then re-installed again.  

v1.14 does not have the latest changes for the Export format.

Powered by nopCommerce

Copyright © 2019 FoxNetSoft. All rights reserved