London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

CSV Import - Price Type

Vote:
 

Hey.

I'm having some issues with the CSV Import in Commerce (10.5) and the "Pricing" - and especially the Price Type field.
Right now our prices on Variant/SKU are just for "Sale Type": All Customers and Default Market.

However, I cannot find information as to what to write in the "Price Type (Name/Id)" mapping to get it to work.
I've tried "Null or Default Value" and I've tried "Dictionary value" but that leads to an empty "Custom Value" collection.

The thing I have gotten to work was to manually edit the mapping file and writing:

 
       
        System.String
        PriceTypeId
        ShortString
        Custom
        0
        True
   

However that seems rather problematic going forth.

Does anybody have some insight into this issue? Such as which CustomValue collection that PriceType reads from so I can create the dictionary values, or whether I should do something else entirely?


Thanks in advance.

#178452
May 11, 2017 9:56
Vote:
 

Hi Allan

I am not familiar with the CSV import and not at all sure this will help you but the PriceType is a system enum:

public enum PriceType
{
    /// <summary>
    /// Gets prices valid for all customers. PriceCode must be an empty string when AllCustomers is specified.
    /// </summary>
    AllCustomers,
    /// <summary>
    /// Gets prices valid for a specific customer. PriceCode must be the customer's username.
    /// </summary>
    UserName,
    /// <summary>
    /// Gets prices valid for a specific price group. PriceCode must be the price group identifier.
    /// </summary>
    PriceGroup
} 

Have you tried setting it to "All Customers", "AllCustomers" or just 0?
(It is also defined in [dbo].[PriceType] in sql.)

If it is PriceTypeId it asks for it should be '0'.

I hope it can give you a new idea. :)

#178491
May 11, 2017 17:33
Vote:
 

Hi.

Thanks, but the problem (well, one of them :) ) is that if I select Dictionary Value in the mapping file, the "Custom Values" drop down is empty and I cannot select from the Enum, because it's not a Dictionary Value and I cannot create the Dictionary.

#178589
May 15, 2017 13:01
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.