Home Cloud Account Management Support Forums Downloads About Us  

Blue Alligator Support Forums

Support for the Blue Alligator applications

You are not logged in.

#1 2012-11-27 08:47:04

paul dolan
Junior member
Registered: 2012-10-31

product list

hi, i have saved my product list as csv file (same as customer list, locations etc), but am getting following message:

Unknown type of file or filename contains invalid symbols (products.csv). Please see below for more information regarding filenames.

my images have been uploaded as eg: alpine_red & apline_red_a (for additional image)

my product list has the product code apline in the first column.

kind regards

Offline

 

#2 2012-11-27 09:45:55

admin
Administrator
Registered: 2008-02-09

Re: product list

When uploading data files, the cloud account will only accept filenames that have been set up in your file mappings screen - make sure you have set up a filename for your product file upload.

Offline

 

#3 2012-11-27 13:45:27

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

hi, many thanks for this. all seems to have uploaded ok.
i ahve now uploaded catalogue & catalogueproducts. these are showing in database information under the heading filter data as 2 catalogues (0 viewable). product data is showing 0 products (0 viewable)........must have done something wrong here?

Offline

 

#4 2012-11-27 15:52:56

admin
Administrator
Registered: 2008-02-09

Re: product list

This could well just be a matter of timing - after checking some stats against your cloud account, the last download from the cloud on your iPad was initiated three minutes before the last process files process was run. Simply perform another download on the iPad to pick up the latest data from the cloud.

Offline

 

#5 2012-11-27 17:04:10

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

hi, tried this but database information same as on original post.
i will give it some thought this evening.
i am on road for most of tomorrow but will probably be back in touch by end of week.
many thanks for help/suggestions so far.
cheers

Offline

 

#6 2012-11-27 17:11:14

admin
Administrator
Registered: 2008-02-09

Re: product list

Try using the Force a full download option then performing a download from the cloud on the iPad.

Offline

 

#7 2012-11-30 14:30:33

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

hi,
done this and finally saw images & some description. however i still have isuues and am sure it is something simple i havent done correctly. speaking with another guy this weekwho swears by the app so determined to get it right.
ideally i could probably do with a number to ring but appreciate all support is through forum.
basically we sell bedding. if you can imagine we have a design (alpine) which is in 3 sizes (sb, db & ks). we would also have 3 colours red, blue & grey. our product code sequence for bedlinen always begins with P followed by part of the design name, in this case 'ALP', followed by 'D' for duvet set, then either 1 (sb) 2 (db) or 3 (ks) them finally the colour ref - 'M' (red), 'C' (blue) or 'L' (grey). therefore:

PALPD1M  sb duvet set alpine red
PALPD3L   ks duvet set alpine grey
PALPD2C  db duvet set alpine blue

the codes used do not relate to the images as they would'nt mean anything to customers. they are kept on file as ALPINE_RED and so on. but this image then relates to 3 different sizes.

the demonstration product list (for bowls etc) i printed off has an alphanumeric code per item and looks like the code is the 'design' name.

i have created my product list with the name apline covering 9 different products (3 sizes x 3 colours) but it is only picking up on the first alpine product in the sequence.

any suggestions?

kind regards

Offline

 

#8 2012-11-30 15:37:12

admin
Administrator
Registered: 2008-02-09

Re: product list

Each entry in your product list would need to have a unique product code, so to cover 3 sizes x 3 colours you would need to set up nine products.

There is a PhotoRef field on the product that can be used as an alternate image name for the product (rather than the system assuming the image name is the same as the product code). This allows you to re-use the same image for multiple products.

For further filtering, you could set up family codes for the different attributes of the product, e.g. family code 1 for a product could be set up as the design, family code 2 as the size and family code 3 as the colour. See the following topic for more information http://www.bacapps.co.uk/forum/viewtopic.php?id=94

Offline

 

#9 2012-11-30 16:23:29

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

hi,
thanks again.

'PhotoRef' field......cannot see this on product.csv template nor on demonstration template. should this be done on the configuration page on cloud? 6th option?
printed off details of family codes which i am pretty straight with. we have various brands within the range so can work these into family codes.

my main priority is just to get to codes to recognise the images for the moment.

kind regards

paul

Offline

 

#10 2012-11-30 16:47:47

admin
Administrator
Registered: 2008-02-09

Re: product list

The template files should be regarded as examples only and may not include every possible file or field that is available (we're conscious that we need to update the template files at some point).

The Sales Presenter Import File Formats document in the downloads section will always contain the latest information on file formats and available fields.

Essentially, you can just add another column to the end of your products.csv file for the photo reference then (after uploading your file) set up a field mapping for that column.

Likewise, users can also remove columns from the template files that they're not interested in using/won't be mapping.

Offline

 

#11 2012-12-07 15:14:52

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

hi
have filled some (not all in case waste of time) items in PhotoRef column of the products.csv file then did following:

uploaded data file
mapped photo ref
updated
processed files

then download onto ipad.

no images shown for the items i have applied entry in PhotoRef column. photos had been uploaded previously.

any suggestions?

kind regards

paul

Offline

 

#12 2012-12-10 10:15:47

admin
Administrator
Registered: 2008-02-09

Re: product list

I've double-checked your field mappings and the PhotoRef field is currently mapped as the StreamPrice10 column from your products.csv file rather than the PhotoRef column.

Offline

 

#13 2012-12-11 09:20:24

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

brilliant............apologies for very basic error.

will link rest of my images.

will no doubt be in touch again at some point but linking images to product refs i think will have been my biggest hurdle.

many thanks for you help

Offline

 

#14 2012-12-11 15:28:20

admin
Administrator
Registered: 2008-02-09

Re: product list

No problem. Glad you're making progress.

Offline

 

#15 2012-12-20 08:48:25

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

hi,
flying with this now.
have raised some order placed by customers over phone and sent them copy emails etc which they are very impressed with.

i have entered family codes (x5) on the familycodes.csv file and have married these up on the configuration with the same 5 headings. the headings i have used are: bed, bathroom, throw, kids & kitchen. these i expected to appear as 5 buttons on he sales presenter with the option to narrow down further using he remaining family code options.
as things stand the only button that appears in 'bed'. when i click on this the remaining options are shown on a drop down list.
please can you let me know where i have gone wrong with this assuming you can check on what i have downloaded.

once i have done this i think i will be happy enough. i have a colleage who has yet to start with his ipad so will get him to purchase the app. i am assuming he will be able to download all csv files i have already prepared for my unit.

the one thing i havent attempted yet is to get our stock figures onto the unit, but will worry about this in the new year. for now at least i can start new year without carry book with huge book of photo, seperate order pad, separate price list, etc etc etc.

thanks for all your help setting up. i know yu have probably answered my questions a hundred time to other users.

cheers

paul

Offline

 

#16 2012-12-21 10:30:28

admin
Administrator
Registered: 2008-02-09

Re: product list

The five family code buttons correspond to the five family code fields on the product.

The codes you specify in the FamilyCode1 field on the products will appear in the drop-down list for the first family code button, FamilyCode2 field in the second family code button and so on.

I'd say that they way you've set up your codes so far is correct. Your first family code button shows you a drop-down list of "Bed", "Bathroom", "Throw", "Kids" and "Kitchen".

This allows you to narrow down your product browsing to one of these categories/departments/product types (you probably want to configure the button heading to be something generic along these lines).

What you can then do is to start populating the FamilyCode2 field on your products to sub-categorise them.

For example, for your "Bed" products you could set the FamilyCode2 field to something like "Duvet sets", "Pillowcases", "Sheets" and so on.

For "Kitchen" products, you may want to set the FamilyCode2 field to something like "Gloves", "Aprons" and so on.

This means that, once you've selected "Beds" from the first family code button, the drop-down list for the second button will only show the family code 2 entries that relate to beds.

You can then expand on this with the third, fourth and fifth family codes as required. For example, for products with a FamilyCode1 field of "Beds" and a FamilyCode2 field of "Duvet Sets" you could start setting up FamilyCode3 fields such as "Single", "Double" and "King-size".

The following topic gives some examples of setting up family codes: http://www.bacapps.co.uk/forum/viewtopic.php?id=94

Offline

 

#17 2013-01-02 16:38:37

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

hi
just returned today but making progress thanks to your reply.
i am going to try 'force full download' this evening at home (awaiting wireless connection in office and having to use unreliable 3g).
in the 1st family code column i have 5 variants and have given this column the title 'range'.
however when i click on the range button on ipad it only gives two options. like i say, a full download might fix it unless you can see anything obvious.

kind regards

paul

Offline

 

#18 2013-01-02 17:47:46

admin
Administrator
Registered: 2008-02-09

Re: product list

Your familycodes.csv file needs to contain a comprehensive list of all possible family codes that you've used in the family code 1-5 fields in your products.csv file.

I can see that you've set up family code 1's in your product file such as bathroom, kitchen, bed and so on...

However, out of the ones mentioned above, only bathroom currently exists in your familycodes.csv file. Therefore you won't see the other two ranges in the drop down list when you press the first family code button.

Offline

 

#19 2013-01-16 11:15:42

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

hi,
when i log onto sales presenter and select product catalogues i am being logged out and returned to ipad home screen.
i have made changes this morning to display sequence selecting photo ref rather than product code. this was assuming when scrolling through i would just see one picture per design rather than the same picture for various size options. i cant think this will be causing it to log out.

my colleague has been handed his ipad so he purchased the app etc. i dont think he needed to register seperately as he will use the same data and images i have set up for my own use. he doesnt really need access to the cloud expect to download from it as i will probably end up doing the housekeeping myself.

he being logged on wouldnt stop me from logging on???

i have also started to create a 'clearance' catalogue just trying 2 designs to begin with. won't know how successful i have been until i can log on.

puzzled

cheers

paul

Offline

 

#20 2013-01-16 11:42:58

admin
Administrator
Registered: 2008-02-09

Re: product list

Changing the product display sequence should only alter the physical sequence in which the products are shown on the screen. If you change the sequence back from photo ref to product code does it start working again? (just trying to establish whether or not its an issue with the photo ref field).

Your colleague doesn't need to register for a cloud account separately. The system is designed to allow any number of iPads to attach to the same cloud account. Logging in on one iPad won't prevent someone from logging in on another iPad.

Offline

 

#21 2013-01-16 12:51:40

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

hi

yes seems to allow me to stay in sales presenter having changed sequence back.

might give it a few days and try again.

there is also now the 'clearance fine i mentioned although nothing in it.
in the catalogueproducts file i have changed from bedmaker to clearance in the 1st column and have entered clearance prices in the clearance column on the product list thinking this would override the standard price. have also mapped this new column and processed files.


cheers

Offline

 

#22 2013-01-16 13:43:55

admin
Administrator
Registered: 2008-02-09

Re: product list

paul dolan wrote:

yes seems to allow me to stay in sales presenter having changed sequence back.

might give it a few days and try again.

ok, we'll investigate why it doesn't work for you when you set the sequence to use the photo ref field.

paul dolan wrote:

there is also now the 'clearance fine i mentioned although nothing in it.
in the catalogueproducts file i have changed from bedmaker to clearance in the 1st column and have entered clearance prices in the clearance column on the product list thinking this would override the standard price. have also mapped this new column and processed files.

The non-display of clearance products was our fault - apologies - a bug was introduced into version 1.1.9 which stopped the two dynamic catalogues from showing any products.

This has been fixed in version 1.2.0 which became available in the Apple App Store today.

With regard to the clearance price overriding the standard price, there is a configuration setting at the bottom of the Configuration->Order Entry section of your cloud account which lets you determine which selling price should be displayed by default (e.g. default to clearance price, if present).

Offline

 

#23 2013-01-16 14:35:57

admin
Administrator
Registered: 2008-02-09

Re: product list

Displaying your products in photo ref sequence should now be ok - this was an issue with the cloud configuration setting

Offline

 

#24 2013-01-16 17:00:11

paul dolan
Junior member
Registered: 2012-10-31

Re: product list

hi,
yes. lets me back in with photoref as sequence but doesnt have the result i was hoping for.
i have, for example, a design eden which would have 4 sizes of bedlinen, plus a bedspread, plus a cushion, plus curtains - 7 options for the main shot/image. what i was hoping to acheive was just a single shot, then when it is clicked on all the othetr options are shown as available.
just think it will make it easier/less repetitive when showing customers (one main image rather than 7 of the same). maybe it is something i will have to do through family codes.

any suggestions???

cheers

paul

Offline

 

#25 2013-01-16 18:32:45

admin
Administrator
Registered: 2008-02-09

Re: product list

You would have to do this via family codes for the moment since each product is treated as an individual product.

We are currently working on a feature for a few customers that gives the ability to link products so longer term this new feature may satisfy your requirements.

Offline

 

Board footer

Apple, the Apple logo, iPod, iPod touch, iPad and iTunes are trademarks of Apple Inc., registered in the U.S. and other countries. iPhone is a trademark of Apple Inc. App Store is a service mark of Apple Inc.
© Copyright 2009 - Blue Alligator Company Limited. All rights reserved.