Profile: JohnW

I confirm the following now works correctly following the update

Sku,IGNORE,IGNORE2,StockQuantity,IGNORE3
"SKUTEST","Test","Test","15.0","Test"

The "Field enclosure" doesn't seem to work very well with | or "

I'm reliant on an automated export from a legacy system that uses " as an enclosure for all columns. It also puts the quantity in as a decimal in quotes

Sku,IGNORE,IGNORE2,StockQuantity,IGNORE3
"SKUXXX","Test","Test","13.000","Test"

But I can't even get "simpler" versions to work e.g.

Sku,IGNORE,IGNORE2,StockQuantity,IGNORE3
"SKUXXX","Test","Test",13,"Test"

I have a template
Column 0 -> Sku
Column 3 Stock Quantity

WORKS
Sku,IGNORE,IGNORE2,StockQuantity,IGNORE3
Test,Test,Test,"11",Test

FAILS - says file has no rows
Sku,IGNORE,IGNORE2,StockQuantity,IGNORE3
"Test",Test,Test,"11",Test

FAILS - says file has no rows
Sku,IGNORE,IGNORE2,StockQuantity,IGNORE3
Test,"Test",Test,"11",Test

I've tried setting Field Enclosure to " and to leaving it blank
I've tried setting up column mappings for columns I'm ignoring that didn't help

It fails if the SKU (Column0) has quotes
It fails if one of the Ignore columns has quotes

Apologies if I'm doing something silly

Alternatively it looks like the Plugin https://www.foxnetsoft.com/nopdicountrulebuyxgety
might expand the way discount rules work so we could use that.

Assuming that's the case is it possible to use the Import Manager to import Discounts? I can't see that in the Entity table (appreciate this might be a little complex as discounts can apply to products and also be restricted to products)

We are likely to custom build - but if we can take some pain away with your plugins, that would be great.

We recently purchased Automatic Updates plugin - it works great - thank you.

On a different site we are developing Grouped Tiered Prices, to do this we are creating new tables.

e.g.

Group (ID, Name)
GroupProduct(GroupID, ProductID)
GroupDiscount (GroupID, Quantity, DiscountPercentage

The table designs are yet to be finalised e.g. the table names or fields might change

Is it possible to use the import manager to import into new tables that don't exist as part of NOP Core? If not could I submit this as a feature request. I'd be happy to edit underlying config files rather than use the admin features, if that makes the feature easier.

I can see its possible to import into a variety of the existing tables. We would almost certainly purchase a multidomain version of the plugin if its possible.

I've figured it out the problem occours when

Product SKU = Y
Product Attribute SKU = Y

So the SKU of the product and the SKU of one of its product attibutes is the same

So this is in part a problem with our clients configuration

Although I suppose when inventory method = "Track By Product Attribute" the product SKU should be ignored

For clarity I have a file

SKU, Quantity
X, 10
Y, 20

Item X is imported with quanity 10 if inventory method in "Track Inventory"
Item Y is not imported its inventory method is "Track Inventory With Product Attributes"

The plugin is not working when the inventory method is 'Track Inventory By Product Attributes'. Is there a bug?