Download or Delete Products in ShopSite

Occasionally you may have the need to download and/or delete a set of products. Maybe you want to download the products to a spreadsheet so you can edit them and then reupload. Maybe you want to remove them from the store but there is the potential for putting them back. Here is how you can accomplish this task.

Let’s say you need to get products by brand. Of course, change the search to anything you can search by to get all the products you need.

To download all the products, in ShopSite do the following:
Go to Products
Search by Brand, contains [brand name]
Right below it in a link, click on “select all [number] matching products”
Click the image for download (down arrow)
Make sure the “all fields” is selected
Give it a file name that makes sense, save it with a .txt extension
Proceed

This will save it to your computer. You can then open it in excel and save it as an excel file.

This, however, does NOT save your pictures. If you need them, you want to download (ftp) them to your local computer or leave them on the server.

To delete the products, in ShopSite do the following:
Click the gear for “settings”
Scroll down to product deletion and check if you are deleting the product images. If it is checked, make sure to get the images before you delete the products. If unchecked, the images will remain in the media directory. NOTE: because of space limitations, I recommend saving the images locally so that you can delete them from the store and have this box checked.
Save changes (if you made any)
Go to Products
Search by Brand, contains [brand name]
Right below it in a link, click on “select all [number] matching products”
Click the trash can
Click yes to delete
Publish site

That’s it, your products will be deleted, but you will have a spreadsheet copy of them.

Certified ShopSite Designer & Developer!

We are happy to announce we have received our certification for Design and Development of sites using ShopSite, our favorite shopping cart!

We have been designing and developing sites using ShopSite for years, but just never applied for certification.  And we passed with flying colors.

Check out our portfolio page to see some of the sites we’ve designed/developed.  In need of a shopping cart, let us get you started.

ShopSite certified developer
ShopSite certified developer
ShopSite Certified Designer
ShopSite Certified Designer

Welcome back Nelle and Lizzy!

PSL Designs would like to welcome back Nelle & Lizzy, Personalized, Hand-Stamped Jewelry.  All redesigned and ready to go, check out their new site:  www.nelleandlizzy.com .

Personalized Jewelry by Nelle and Lizzy
Nelle and Lizzy is sparkling new!

This user friendly site has a great product personalization tool and is of course mobile friendly.

Need a Valentines Day Gift?  This would be a great time to checkout Nelle and Lizzy and get some bling for the special loved ones in your life.

Be sure to let us know what you think of their site!  :O)

January Promotions at a Stationery site!

One of my customers, www.janicesinvites.com,  is having a great sale. Check out these specials!

Janices Invites Personalized Stationery
Janices Invites Personalized Stationery

Check out these 3 January Promo Code Specials and take
advantage of double discounts!

 

1. Boatman Geller Foldover Notes/Thank You Notes: Additional 20% off our already reduced 25% off retail!

CODE: NEWYEAR20

Stock up on all you stationery now! Personalized with name or initials. Great for thank you notes from kids, miss you notes from mom, and any time you just need to keep in touch!

 

folded-note-card-promo

2. Valentines Day Cards, Invites, Stickers and Plates: Additional 25% off our already reduced  25% off retail!

CODE: HEART

Great selection of cards for the elementary student classmate handout. Personalize with the students name. Stickers to put on those Valentine goodies and treat bags. Great for you teachers to hand out to your students! Photocards to send to relatives from the kids. Valentines Day plates to give as gifts or use to share treats.

Valentines Day Stationery

3. Boatman Geller Letterpress Products: 25% off, this line is normally NOT discounted!

CODE: LETTERPRESS25

This line lets you design your own stationery … add an icon, two colors of printing, solid or pattern envelope liners, ribbons. Can be sophisticated or casual, design as you wish. Great for Bar/Bat Mitzvahs, Weddings,  Moving Announcements, Baby Announcements, Invitations, Thank You Notes, anything you need. And we  are also discounting matching napkins and cups so you can get everything for your party!

Boatman Geller Letterpress Stationery

 

Where Have I Been?

Haven’t fallen off the planet … been a crazy few months.  With the Google announcement of wanting every site to be “mobile friendly”, many clients felt it was time to do just that.  Some sites have gotten a complete rebuild, some are now mobile friendly.  :O)

My most recent rebuild was www.janicesinvites.com.  This was a fun one as I was able to use a lot of ShopSite’s new features and templates.  Check it out and let us know what you think!

Janices Invites Personalized Stationery & Gifts
Janices Invites Personalized Stationery & Gifts

Preparing for the Holidays

It is getting to be that time again.  Thanksgiving will be here before we know it.  Is your website ready?

Are you ready?
Are you ready?

Checkout every aspect of a purchase … make a purchase yourself on your own site using a computer and a mobile device.  If possible have a friend do it with you in the room so you can really see where there might be problems.  Be sure to clean up everything possible and streamline the buying process.  If the site lags, see if you can clean up what is causing the slow down.  Be sure to check the order confirmation page and email the customer gets.  These are often overlooked by manufacturers.

Once you are sure everything is working as it should it is time to get ready for your cyber Monday incentives. Decide what type of special you want to have.  See what your competitors are doing.  Perhaps free shipping or buy so many get one free.  You should try to make this a “better” sale than something you normally have.  It is also a good way to clear out inventory if you have a lot of a certain product.  Speaking of inventory, be sure you have enough of what you are offering to keep customers happy.

It is also a good idea to advertise that you will have a Cyber Monday special.  Create a banner for your home page and be sure to post it to your facebook, twitter and blog.  You don’t have to give complete details, just enough to get your customers interested.  Then on the Sunday before, you can send out a blast of what the special will be.

Setup your special and TEST IT ahead of time!  Make sure it works before you go live with it.  Nothing worse than having a bunch of potential sales fall through and upsetting customers because something wasn’t setup correctly.

If you are having any other holiday promotions, now is the time to get them ready.  Create all your banners, coupon codes etc… to have them all ready during your busiest time.  The more prep work you do, the calmer the time can be.

How to add a Product to ShopSite

If you already have a store with products in it … here is the easiest way to add additional products if you want to add them one at a time:

Images:

  1. Create your images for your product.  Have these ready.  Create them at the highest size/resolution you need them online.  Upload them to ShopSite by going to Images.
  2. Images > click the directory you want  them in > upload images.
  3. If you need multiple sizes of images and use  different sizes, click on the button to create resized images > click proceed

Create the product:

  1. login to ShopSite, go to Products
  2. find a product that is very similar to the one you want to add, click on Copy
  3. Put in a product name and SKU > Save

Edit the new product:

  1. Go to the new product,  click on the product name to edit it.
  2. Change all fields necessary.  Be sure to review them all.
  3. Fields that copy over blank that you need to add something to:
    1. file name – be sure to give your product a descriptive file name, no unusual characters, just alpha numeric with hyphens, end with .html or .htm.
    2. product on pages – click this button to add your product to store pages
  4. Save
  5. publish
  6. MAKE SURE to verify your product is correct, view it in your store and add it to the cart to be sure it works as expected.

Quotes in Meta Tags

So, you are seeing strange results on you webpage … your meta description is showing on the page and it shouldn’t … what gives?  Maybe you recently added schema.org tags to your site and now those are showing on the page and shouldn’t … what is going on?

A common issue that can cause text to show up on your website that you don’t want is the use of quotes.  Let us look at the meta description tag.  It commonly looks like this:

<meta name=”description” content=”Here is my description for Google SEO.  I sure hope Google finds me!”>

Now let’s say you have a quote in the content of your tag, like this:

<meta name=”description” content=”Blue Ball.  10″ diameter. $4.50.”>

This will cause a problem with the meta tag because the quote after diameter actually closes the quote after the content=.  Herein lies the problem.  So we really want a quote as it means inches in this case.  What can we do?

Use the HTML code for quote:  &quot; .  Yes, this looks strange, but it will solve your problem.  Your meta tag should now look like this:

<meta name=”description” content=”Blue Ball.  10&quot;  diameter. $4.50.”>

Have tons of products in a spreadsheet … do a find and replace on the column that needs it.

Use this method in ALL your meta tags to stop any unforeseen problems.  :O)

Pinterest Gifts Feed and ShopSite

Pinterest Gifts Feed
Pinterest Gifts Feed

What is the Pinterest Gifts Feed?  Taken directly from the Pinterest site:

“We know people love to use Pinterest for shopping ideas, which is why we’ve created a new Gifts feed of all the different things you could buy.

The work-in-progress feed lives with our regular categories but it’s special because it only shows Product Pins. Product Pins show extra details like pricing, availability and where to buy right on the Pin so Pinners can decide which products are right for them.

So far, we’ve learned that Product Pins get higher click-through rates than regular Pins and make your brand more visible because of the logo on the Pin.  Pinners also get email notifications when Product Pins they’ve saved drop in price.

The Gifts feed also includes a few price filters so you can find something for every budget. $$$$ means the price is greater than $200, $$$ means the price is between $50-$200, $$ means the price is from $25 to $50 and $ is anything less than that.”

Certainly seems like something any seller would want to include with their products.

How do you do it?

PInterest requires you to have what they call “rich pins”.  Check out their developer page for more on this.  ShopSite makes it easy.  Using ShopSite’s custom templates, you can add the information to the head section of the product page and ShopSite will fill in the info for you that is required.  Keep your custom template clean by creating an “include” file that holds this information.  Then wrap product specific ShopSite tags with open graphic tags.  You then have to verify you have done this correctly with pinterest.

Oh, and an extra benefit … Google will also read this information and it will help them in displaying your pages in searches.  :O)

Happy pinning!