I’m having a problem importing special pricing values correctly into Magento. Here is the setup.
Within Magento, we have defined two websites and one store and store view in each website, one store is for the public and the other is for our employees only. When I import a product that is to appear in both stores, I have it listed in the import CSV file twice (using SKU as the unique identifier) with all values duplicated except for:
- special price
What I want:
The employee store should see the normal price and then see their special price. The public store should not have a special price. We are trying to implement this by leaving the “special price” value blank in the public website/store CSV record and entering a value in the employee website/store record.
What actually happens:
The results after the import are that the “default store view” value of “special price” is being set to the employee special pricing even though we want it to be blank. The public store view within Magento after the import results in the use of the checkbox to use the “default store view” value, which we don’t want. We want the pubic store value of “special price” to be blank, meaning the public doesn’t get one.
I know the values of “website” in the datafile are set correctly. The value of the “store” column are all set to “admin”, taking the Export Products profile as an example. Should the “store” value be something different, something particular to the store represented by the record?
Also… can someone explain the logic of how the “default store view” values are populated? Should we include a third record in the import file to represent what we want the “default store view” values to be? Does the order of the records in the import file determine what values are stored where during the import?
Just looking for clarification on how things are done so I can understand.