Author Topic: Importing Historic Sales?  (Read 16519 times)

cheeseroc

  • Newbie
  • *
  • Posts: 1
    • View Profile
Importing Historic Sales?
« on: January 01, 2024, 07:48:30 pm »
Starting using the software in June and it is amazing.  Looking at my annual report and I think it would be awesome if I could add my first quarter sales into the excel.  I downloaded my sales history from ebay.  Is it as simple as cutting and pasting into my sold items tab or is there a tutorial on how to do it?  Looking forward to 2024!

Scott

  • Administrator
  • Sr. Member
  • *****
  • Posts: 437
  • https://mycostpro.com
    • View Profile
    • MyCostPro
Re: Importing Historic Sales?
« Reply #1 on: January 02, 2024, 05:26:05 pm »
Hi,
You can enter sales manually, it is important that you add all of the required information for these sales for them to incorporate correctly with the rest of the downloaded data.
The following are the minimum fields that must be manually input for these sales:

• Item/Transaction ID (Unique) - This can be filled in with any value.
Note: This column may be hidden by default.

• Quantity - Fill in with the quantity of this item sold in this transaction.

• Sale Date - Fill in with the date of this sale.

• Month Sold - Fill in with the first day of the month that this item sold. For example if the item sold on "3/20/2022", you would fill in "3/1/2022" (without the quotes).
Note: This column may be hidden by default.

• Sale Price - Fill in with the price that the item sold for.
« Last Edit: January 03, 2024, 03:57:41 pm by Scott »