Change Selling Migration

Change Selling Migration

 Change Selling Migration 

 

Change selling facilitates to change the selling price and MRP of the items. The selling price of the products will change more often in accordance with market change. Especially, the prices of the items in supermarkets and grocery stores will always be changing overnight. Using Change Selling screen, You can load the items and change the selling price and mrp in a minute

 

Purpose : By using the Change Selling Migration option, by using this option we can update the Selling and MRP prices for the items in bulk mode.

 

Page Navigation : Tools → Master Migration

 

Process involved in creating change selling through migration

 

  • Generate the Sheet in master migration

  • Create the change selling sheet

  • Upload the sheet

  • If you face any error during upload, check in Upload Status

 

 

Fields In Detail :

 

Following are the fields of the Change selling CSV file and everything you need to know about it :

 

 

Field

Description

Item Name

Enter name of Item

Selling

Enter the new selling Rate of an item

MRP

Enter the new MRP Rate of an item

Old selling

Enter the old selling Rate of an item

Old MRP

Enter the old selling Rate of an item

Location

Select the particular location

Batch No.

Enter the Batch number

Expiry Date

Enter the particular expiry date

Packed date

Enter the specific packed date

 

 

 

 

 

How to do Change selling Migration in TruePos ?

 

1. Select the Master Migration option under Tools.

 

1676365018260

 

 

2. Under the option for sheet Generation, choose Change selling upload from the master list.

 

1676365045439

 

 

3. Enable the field which need to be added in sheet. You can specify certain fields as mandatory also. After selecting the fields, Click on Save Config and Download the CSV. The excel sheet will get downloaded (Kindly take note of the column size, Data type and Column value before filling up the sheet and make sure the values filled up in the sheet satisfy the conditions)

 

4. Fill out the provided template with the information of Item name, selling, MRP, old selling rate, old MRP, Expiry rate, Packed date.

 

1676365128169

 

5. After filling up the sheet,  Click on Upload Sheet and select the master then browse the file and click on Upload file. Once uploaded will get message as successfully uploaded.

1676365157953

 

 

7. After clicking 'Upload File' you will get the confirmation pop-up and then press 'OK'.

8. Then you will get the successful message pop-up and Press 'OK'.

 

9. Verify that the uploaded Customer update migration information is accurate. Access Master → Item  → Item  → Search → Edit

 

 

FAQ :

Q1) Can cost price be changed in change selling menu?

Answer : No. We cannot change the cost price. If you have inwarded the stocks with wrong cost price means either do the Return process or proceed Stock Update and again do the inward stock.

Q2) Can change selling be done batch wise?

Answer : Yes, change selling can be done batch wise by using the "Enable batch details in change selling" configuration in Business Configuration Screen.If the item has multiple batches, you will be able to select the batch, after selecting the item

Q3) Is it possible to provide selling price below cost price? Need this for business requirement

Answer : Although it is not advisable to provide selling price below cost, it is possible. Enable the configuration "Allow change selling below cost" should be enabled from Business configuration. Updating the selling price less than cost price is not a correct process because it will result in negative profits.

Q4) Is there any ways to update change selling in bulk?

Asnwer : Yes, it is possible via Change selling upload migration. Refer the 'Change Selling Migration' to know about the migration process.

Q5) Is the Change Selling applies to Branch wise?

Answer : Yes, We have option for using change selling Branch wise. For enabling the same, Kindly reach us through live chat or send an email to retaileasycloud-support@gofrugal.com

Q6) While uploading any error how to check the error details?

Answer : After uploading you will get the error pop-up as 'Invalid records exists click "Load" button in Upload Status to correct invalid data'.

Go to the path 'Upload Status' and you can able to see the "Reason", kindly verify the same and correct the datas in sheet and re-upload it via 'Upload Sheet'

 

 

    • Related Articles

    • Change Selling

      Change Selling Purpose : To change the selling and MRP price after the inward(Purchase/Opening Stock) transaction done Intro on Change selling : Change selling facilitates to change the selling price and MRP of the items. The selling price of the ...
    • What is the purpose of Change selling migration in TruePos ?

      Change Selling Migration Purpose :By using the Change Selling Migration option, we may amend or update the old adjustments for Selling Price or MRP in bulk. Page Navigation :- Tools >> Master Migration Process involved in creating change selling ...
    • Item Price Change

      Purpose: The Item Price Change feature in TruePOS allows businesses to modify the prices of their products with ease and precision. This feature ensures seamless price updates across all relevant points of sale, helping businesses stay competitive ...
    • Item Master

      Purpose: Item (also known as Product, Part, Article and SKU - Stock Keeping Unit) refers to the name of the service or a thing which is produced or served. The term "Item Master" constitutes an item database where we can define the features and ...
    • Price Level Master Migration

      Price Level Master Migration Price Level Master Migration Purpose : Price levels allow you to set multiple pricing options for each inventory item. Each customer can be assigned a specific price level, which determines the default item price that ...