Author Topic: COGS List  (Read 16262 times)

dean0088

  • Newbie
  • *
  • Posts: 2
    • View Profile
COGS List
« on: August 28, 2017, 07:51:07 pm »
Im not an excel superstar is there a way I can take my inventory from the live listings tab and paste it to COGS area rather that typing in 500 listings?

Scott

  • Administrator
  • Sr. Member
  • *****
  • Posts: 438
  • https://mycostpro.com
    • View Profile
    • MyCostPro
Re: COGS List
« Reply #1 on: August 28, 2017, 08:05:37 pm »
Yes, you can, just follow these steps:

1. On the Active Listing tab, set the "CLICK LAYOUT ASSIST BUTTON" to "OFF"  (You cannot copy and paste while it is set to "on")

2. On the Active listing tab, highlight the range of item names with left click (hold down, drag to select, let go of left click when selection is complete).

3. Right click on that selection and select "COPY"... or hit CTRL-C (keyboard shortcut for copy)

4. Go to your product detail page, select (single left click) the top cell where you want the product names to go.

5. Right click and select PASTE-SPECIAL, and then select VALUES ONLY.  (The "Values only" option for PASTE will prevent the formatting from changing, keeping everything looking as it should)


Post here if you have any trouble!  Thanks!

Done.